It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×6,077
×5,829
×3,952
×403

question asked: Jan 05 '15, 8:20 a.m.
question was seen: 3,973 times
last updated: Jan 08 '15, 8:33 a.m.

Related questions

FAQ - How this Forum works

[closed] RM - Full ETL Job failed

0
VK L (817●7●155●159) | asked Jan 05 '15, 8:20 a.m.
closed Jan 08 '15, 8:33 a.m.
Hi All,
I invoked RM - Full ETL Job . It failed with below errors [* from rm-etl.log]:


2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN com.ibm.rdm.fronting.server.rrs.etl.util.ETLTracer  - Preceding event: '751999347fca19f2b9d86c1c823dd8f7' from 'Looking up owner'
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN com.ibm.rdm.fronting.server.rrs.etl.util.ETLTracer  - Preceding event: '0d7e3c11ae6b2e9906872a0de39ad086' from 'Looking up project'
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN com.ibm.rdm.fronting.server.rrs.etl.util.ETLTracer  - Preceding event: 'RRC Requirement' from 'Looking up classification'
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN com.ibm.rdm.fronting.server.rrs.etl.util.ETLTracer  - Preceding event: 'CALL' from 'RMRequirementETL::loadRecordIntoDW(?, record)'
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN com.ibm.rdm.fronting.server.rrs.etl.util.ETLTracer  -     Event subject: name=Visual QA Error Workflow - Pending Error; uuid=993fab5e5fbf9c5a670b5919010a827b; identifier=https://vmrrc.wiley.com/rm/locks/_zff01yvTEeOXBNgaYfmfJA; format=WrapperResource; creatorUUID=751999347fca19f2b9d86c1c823dd8f7; creationtime=2013-10-03 22:19:54.293; modifTime=2013-10-02 21:30:44.492; projectUUID=0d7e3c11ae6b2e9906872a0de39ad086; url=https://vmrrc.wiley.com/rm/resources/_zff01yvTEeOXBNgaYfmfJA; datasrcId=_vVgdIhk_EeSsZco0Dso-9QRRC; extKey2=_zff01yvTEeOXBNgaYfmfJA; reqType=Supporting Resource; isDeleted=false; lookupOwnerId=-1; lookupPrjId=18; lookupReqClassId=23; lookupReqId=7677; lookupCollId=-1
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN com.ibm.rdm.fronting.server.rrs.etl.util.ETLTracer  - Preceding event: 'CALL' from 'RMRequirementETL::updateRecord(?, req)'
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN com.ibm.rdm.fronting.server.rrs.etl.util.ETLTracer  -     Event subject: name=Visual QA Error Workflow - Pending Error; uuid=993fab5e5fbf9c5a670b5919010a827b; identifier=https://vmrrc.wiley.com/rm/locks/_zff01yvTEeOXBNgaYfmfJA; format=WrapperResource; creatorUUID=751999347fca19f2b9d86c1c823dd8f7; creationtime=2013-10-03 22:19:54.293; modifTime=2013-10-02 21:30:44.492; projectUUID=0d7e3c11ae6b2e9906872a0de39ad086; url=https://vmrrc.wiley.com/rm/resources/_zff01yvTEeOXBNgaYfmfJA; datasrcId=_vVgdIhk_EeSsZco0Dso-9QRRC; extKey2=_zff01yvTEeOXBNgaYfmfJA; reqType=Supporting Resource; isDeleted=false; lookupOwnerId=-1; lookupPrjId=18; lookupReqClassId=23; lookupReqId=7677; lookupCollId=-1
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN com.ibm.rdm.fronting.server.rrs.etl.util.ETLTracer  - Suspect event: 'Updating requirement record' from 'RMRequirementETL::updateRecord(?, req)'
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  WARN ng.server.rrs.etl.internal.RemoteRMSnapshotService  - com.ibm.rdm.fronting.server.rrs.etl.internal.etlbuild.RMRequirementETL failed to complete
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData] ERROR ng.server.rrs.etl.internal.RemoteRMSnapshotService  - !!!com.ibm.rdm.fronting.server.rrs.etl.internal.RemoteRMSnapshotService has failed. Aborting all the jobs !!!
2015-01-05 06:39:03,294 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ng.server.rrs.etl.internal.RemoteRMSnapshotService  - End of loading requirements
2015-01-05 06:39:03,310 [WebContainer : 30 @@ 06:24 vlakshmana /rm/service/com.ibm.team.reports.common.internal.service.IReportRestService/updateSnapshotData]  INFO ng.server.rrs.etl.internal.RemoteRMSnapshotService  - -=END=-

Please advise.

Thanks.

The question has been closed for the following reason: "The question is answered, right answer was accepted" by valli Jan 08 '15, 8:33 a.m.

Accepted answer

0
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Jan 08 '15, 8:15 a.m.
Hello Valli,

the logs extract doesn't seem to show any evident cause of the failure.
This might require in depth investigation so you might consider opening a PMR for this problem.

Best Regards,

Francesco Chiossi
VK L selected this answer as the correct answer

One other answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
VK L (817●7●155●159) | answered Jan 05 '15, 8:21 a.m.
Below is the error from rm-driver log file:

2015-01-05 06:44:23,152 [                 Thread-203986] ERROR tional.drivers.jdbc.xml.internal.PageFetcherThread  - com.ibm.rational.etl.common.exception.ETLException: java.lang.NullPointerException
com.ibm.rational.etl.common.exception.ETLException: com.ibm.rational.etl.common.exception.ETLException: java.lang.NullPointerException
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:594)
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.run(PageFetcherThread.java:144)
Caused by: com.ibm.rational.etl.common.exception.ETLException: java.lang.NullPointerException
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:534)
    ... 1 more
Caused by: java.lang.NullPointerException
    at com.ibm.rational.drivers.jdbc.xml.util.SQLRowInMemoryStorage.notifyAvailable(SQLRowInMemoryStorage.java:59)
    at com.ibm.rational.drivers.jdbc.xml.util.SQLRowInMemoryStorage.check(SQLRowInMemoryStorage.java:87)
    at com.ibm.rational.drivers.jdbc.xml.util.SQLRowInMemoryStorage.put(SQLRowInMemoryStorage.java:158)
    at com.ibm.rational.etl.database.services.util.SQLRowFactoryHandler.blockingOrStore(SQLRowFactoryHandler.java:690)
    at com.ibm.rational.etl.database.services.util.SQLRowFactoryHandler.endElement(SQLRowFactoryHandler.java:441)
    at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
    at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanEndElement(Unknown Source)
    at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
    at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
    at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
    at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
    at org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
    at com.ibm.rational.drivers.jdbc.xml.internal.PageFetcherThread.exeFetch(PageFetcherThread.java:504)
    ... 1 more