|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
 |
|
HI GUYS mqsi database exception |
« View previous topic :: View next topic » |
Author |
Message
|
k.srinivas |
Posted: Wed Jun 23, 2004 3:43 am Post subject: HI GUYS mqsi database exception |
|
|
Apprentice
Joined: 16 May 2002 Posts: 29 Location: chennai
|
HI
when iam trying to insert large xml files into oracle9.2 using passthru esql
statement iam gettitng the following exception
- <ErrorInformation>
<ErrorSource>CPM</ErrorSource>
<ErrorDateTime>TIMESTAMP '2004-06-23 12:21:44.796'</ErrorDateTime>
- <ErrorDescription>
- <RecoverableException>
<File>F:\build\S210_P\src\DataFlowEngine\ImbDatabaseNode.cpp</File>
<Line>269</Line>
<Function>ImbDatabaseNode::evaluate</Function>
<Type>ComIbmDatabaseNode</Type>
<Name>cf613eeb-fc00-0000-0080-d5e0916643c6</Name>
<Label>DEV_CPM_TO_PHOENIX_001.INS_INTO_CARGOMAX_INTRAY_TBL</Label>
<Text>Caught exception and rethrowing</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
- <RecoverableException>
<File>F:\build\S210_P\src\DataFlowEngine\ImbRdl\ImbRdlExternalDb.cpp</File>
<Line>273</Line>
<Function>SqlExternalDbStmt::executeStmt</Function>
<Type>ComIbmDatabaseNode</Type>
<Name>cf613eeb-fc00-0000-0080-d5e0916643c6</Name>
<Label>DEV_CPM_TO_PHOENIX_001.INS_INTO_CARGOMAX_INTRAY_TBL</Label>
<Text>The following error occurred during execution of an SQL statement</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2519</Number>
- <Insert>
<Type>2</Type>
<Text>18</Text>
</Insert>
- <Insert>
<Type>2</Type>
<Text>1</Text>
</Insert>
- <Insert>
<Type>5</Type>
<Text>VCDEV</Text>
</Insert>
- <Insert>
<Type>5</Type>
<Text>INSERT INTO CARGOMAX_INTRAYS(MAX_MSG_TYPE, MAX_DATA, MAX_REF, MAX_STATUS, USR_CREATED, CREATED) VALUES(?,?)</Text>
</Insert>
- <Insert>
<Type>5</Type>
<Text>'I', '<CPM_MESSAGE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <AddressAndCommRef> <Priority>QU</Priority> <Addresses> <Address>LGWFRVS</Address> </Addresses> <Addresses> <Address>LGWLDVS</Address> </Addresses> <Addresses> <Address>LHRFFVS</Address> </Addresses> <Addresses> <Address>LONLLVS</Address> </Addresses> <Addresses> <Address>LHRTPXH</Address> </Addresses> <Addresses> <Address>LHROFVS</Address> </Addresses> <Addresses> <Address>LGWGSVS</Address> </Addresses> <Addresses> <Address>LHRVFVS</Address> </Addresses> <Addresses> <Address>SOUFICR</Address> </Addresses> <Addresses> <Address>LHRLLVS</Address> </Addresses> <Addresses> <Address>LHRGAXH</Address> </Addresses> <Addresses> <Address>LHRTFXH</Address> </Addresses> <Addresses> <Address>NRTOOUA</Address> </Addresses> <Addresses> <Address>NRTCGUA</Address> </Addresses> <Addresses> <Address>NRTFFUA</Address> </Addresses> <Addresses> <Address>LHRKZVS</Address> </Addresses> <Originator>LGWFRVS</Originator> <FlightCode>VS</FlightCode> <Date>2004-05-11</Date> <Time>02:29:00</Time> </AddressAndCommRef> <StdMsgIdAndFltRec> <StdMsgId>CPM</StdMsgId> <FlightIdentifier> <AirlineDesig>VS</AirlineDesig> <FlightNumber>901</FlightNumber> <ScheduledDt>2004-05-11</ScheduledDt> </FlightIdentifier> <AircraftRegn>GVFOX</AircraftRegn> </StdMsgIdAndFltRec> <DistribAndLoadInfo> <ULDInformation> <ULDBayDesig>11L</ULDBayDesig> <ULDCd>AKE34488VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>505</ULDWt> <ULDCat> <CategoryCode>BT</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>11R</ULDBayDesig> <ULDCd>AKE34480VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>505</ULDWt> <ULDCat> <CategoryCode>BT</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>12L</ULDBayDesig> <ULDCd>AKE22346VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>505</ULDWt> <ULDCat> <CategoryCode>BY</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>12R</ULDBayDesig> <ULDCd>AKE34354VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>505</ULDWt> <ULDCat> <CategoryCode>BJ</CategoryCode> </ULDCat> <ContourCd>BW</ContourCd> <SplLoadRmks>BW</SplLoadRmks> </ULDInformation> <ULDInformation> <ULDBayDesig>13L</ULDBayDesig> <ULDCd>AKE33803VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>505</ULDWt> <ULDCat> <CategoryCode>BY</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>13R</ULDBayDesig> <ULDCd>AKE22421VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>505</ULDWt> <ULDCat> <CategoryCode>BY</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>13P</ULDBayDesig> <ULDCd>PMC96056VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>1330</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>14P</ULDBayDesig> <ULDCd>PAG81064VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>1358</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>21P</ULDBayDesig> <ULDCd>PAG80013VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>1546</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>22P</ULDBayDesig> <ULDCd>PAG80207VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>2004</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>23P</ULDBayDesig> <ULDCd>PMC96051VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>2372</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>24P</ULDBayDesig> <ULDCd>PMC96261VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>1636</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>32P</ULDBayDesig> <ULDCd>PAG81065VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>776</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>33P</ULDBayDesig> <ULDCd>PAG80134VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>3894</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>41P</ULDBayDesig> <ULDCd>PAG89462VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>3900</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>42P</ULDBayDesig> <ULDCd>PAG80379VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>3854</ULDWt> <ULDCat> <CategoryCode>C</CategoryCode> </ULDCat> </ULDInformation> <ULDInformation> <ULDBayDesig>43P</ULDBayDesig> <ULDCd>PAG89521VS</ULDCd> <UnloadingStn>LHR</UnloadingStn> <ULDWt>4002</ULDWt> <ULDCat> <CategoryCode>BY</CategoryCode> </ULDCat> </ULDInformation> <BulkLoadInfo> <CompartmentSection>5</CompartmentSection> <LoadDestn>LHR</LoadDestn> <LoadWt>30</LoadWt> <LoadCategory> <LoadCategoryCode>BY</LoadCategoryCode> </LoadCategory> </BulkLoadInfo> <BulkLoadInfo> <CompartmentSection>5</CompartmentSection> <LoadDestn>LHR</LoadDestn> <LoadWt>0</LoadWt> <LoadCategory> <LoadCategoryCode>BT</LoadCategoryCode> </LoadCategory> </BulkLoadInfo> <BulkLoadInfo> <CompartmentSection>5</CompartmentSection> <LoadDestn>LHR</LoadDestn> <LoadWt>0</LoadWt> <LoadCategory> <LoadCategoryCode>BJ</LoadCategoryCode> </LoadCategory> </BulkLoadInfo> <BulkLoadInfo> <CompartmentSection>5</CompartmentSection> <LoadDestn>LHR</LoadDestn> <LoadWt>0</LoadWt> <LoadCategory> <LoadCategoryCode>BW</LoadCategoryCode> </LoadCategory> </BulkLoadInfo> <BulkLoadInfo> <CompartmentSection>5</CompartmentSection> <LoadDestn>LHR</LoadDestn> <LoadWt>0</LoadWt> <LoadCategory> <LoadCategoryCode>BBY</LoadCategoryCode> </LoadCategory> </BulkLoadInfo> <BulkLoadInfo> <CompartmentSection>5</CompartmentSection> <LoadDestn>LHR</LoadDestn> <LoadWt>0</LoadWt> <LoadCategory> <LoadCategoryCode>C</LoadCategoryCode> </LoadCategory> </BulkLoadInfo> <BulkLoadInfo> <CompartmentSection>5</CompartmentSection> <LoadDestn>LHR</LoadDestn> <LoadWt>0</LoadWt> <LoadCategory> <LoadCategoryCode>M</LoadCategoryCode> </LoadCategory> </BulkLoadInfo> <BulkLoadInfo> <CompartmentSection>5</CompartmentSection> <LoadDestn>LHR</LoadDestn> <LoadWt>0</LoadWt> <LoadCategory> <LoadCategoryCode>VEX</LoadCategoryCode> </LoadCategory> </BulkLoadInfo> </DistribAndLoadInfo> </CPM_MESSAGE> ', 'CPM', 'N', 'MQLIVE', DATE '2004-06-23',</Text>
</Insert>
- <DatabaseException>
<File>F:\build\S210_P\src\DataFlowEngine\ImbOdbc.cpp</File>
<Line>156</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type />
<Name />
<Label />
<Text>Root SQL exception</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2321</Number>
- <Insert>
<Type>2</Type>
<Text>-1</Text>
</Insert>
- <DatabaseException>
<File>F:\build\S210_P\src\DataFlowEngine\ImbOdbc.cpp</File>
<Line>258</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type />
<Name />
<Label />
<Text>Child SQL exception</Text>
<Catalog>WMQIv210</Catalog>
<Severity>3</Severity>
<Number>2322</Number>
- <Insert>
<Type>5</Type>
<Text>07009</Text>
</Insert>
- <Insert>
<Type>2</Type>
<Text>0</Text>
</Insert>
- <Insert>
<Type>5</Type>
<Text>[DataDirect][ODBC Oracle driver]Invalid descriptor index.</Text>
</Insert>
</DatabaseException>
</DatabaseException>
</RecoverableException>
</RecoverableException>
</ErrorDescription>
- <ErrorneousSourceMessage>
- <CPM_MESSAGE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <AddressAndCommRef>
<Priority>QU</Priority>
- <Addresses>
<Address>LGWFRVS</Address>
</Addresses>
- <Addresses>
<Address>LGWLDVS</Address>
</Addresses>
- <Addresses>
<Address>LHRFFVS</Address>
</Addresses>
- <Addresses>
<Address>LONLLVS</Address>
</Addresses>
- <Addresses>
<Address>LHRTPXH</Address>
</Addresses>
- <Addresses>
<Address>LHROFVS</Address>
</Addresses>
- <Addresses>
<Address>LGWGSVS</Address>
</Addresses>
- <Addresses>
<Address>LHRVFVS</Address>
</Addresses>
- <Addresses>
<Address>SOUFICR</Address>
</Addresses>
- <Addresses>
<Address>LHRLLVS</Address>
</Addresses>
- <Addresses>
<Address>LHRGAXH</Address>
</Addresses>
- <Addresses>
<Address>LHRTFXH</Address>
</Addresses>
- <Addresses>
<Address>NRTOOUA</Address>
</Addresses>
- <Addresses>
<Address>NRTCGUA</Address>
</Addresses>
- <Addresses>
<Address>NRTFFUA</Address>
</Addresses>
- <Addresses>
<Address>LHRKZVS</Address>
</Addresses>
<Originator>LGWFRVS</Originator>
<FlightCode>VS</FlightCode>
<Date>2004-05-11</Date>
<Time>02:29:00</Time>
</AddressAndCommRef>
- <StdMsgIdAndFltRec>
<StdMsgId>CPM</StdMsgId>
- <FlightIdentifier>
<AirlineDesig>VS</AirlineDesig>
<FlightNumber>901</FlightNumber>
<ScheduledDt>2004-05-11</ScheduledDt>
</FlightIdentifier>
<AircraftRegn>GVFOX</AircraftRegn>
</StdMsgIdAndFltRec>
- <DistribAndLoadInfo>
- <ULDInformation>
<ULDBayDesig>11L</ULDBayDesig>
<ULDCd>AKE34488VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>505</ULDWt>
- <ULDCat>
<CategoryCode>BT</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>11R</ULDBayDesig>
<ULDCd>AKE34480VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>505</ULDWt>
- <ULDCat>
<CategoryCode>BT</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>12L</ULDBayDesig>
<ULDCd>AKE22346VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>505</ULDWt>
- <ULDCat>
<CategoryCode>BY</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>12R</ULDBayDesig>
<ULDCd>AKE34354VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>505</ULDWt>
- <ULDCat>
<CategoryCode>BJ</CategoryCode>
</ULDCat>
<ContourCd>BW</ContourCd>
<SplLoadRmks>BW</SplLoadRmks>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>13L</ULDBayDesig>
<ULDCd>AKE33803VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>505</ULDWt>
- <ULDCat>
<CategoryCode>BY</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>13R</ULDBayDesig>
<ULDCd>AKE22421VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>505</ULDWt>
- <ULDCat>
<CategoryCode>BY</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>13P</ULDBayDesig>
<ULDCd>PMC96056VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>1330</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>14P</ULDBayDesig>
<ULDCd>PAG81064VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>1358</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>21P</ULDBayDesig>
<ULDCd>PAG80013VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>1546</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>22P</ULDBayDesig>
<ULDCd>PAG80207VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>2004</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>23P</ULDBayDesig>
<ULDCd>PMC96051VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>2372</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>24P</ULDBayDesig>
<ULDCd>PMC96261VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>1636</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>32P</ULDBayDesig>
<ULDCd>PAG81065VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>776</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>33P</ULDBayDesig>
<ULDCd>PAG80134VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>3894</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>41P</ULDBayDesig>
<ULDCd>PAG89462VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>3900</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>42P</ULDBayDesig>
<ULDCd>PAG80379VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>3854</ULDWt>
- <ULDCat>
<CategoryCode>C</CategoryCode>
</ULDCat>
</ULDInformation>
- <ULDInformation>
<ULDBayDesig>43P</ULDBayDesig>
<ULDCd>PAG89521VS</ULDCd>
<UnloadingStn>LHR</UnloadingStn>
<ULDWt>4002</ULDWt>
- <ULDCat>
<CategoryCode>BY</CategoryCode>
</ULDCat>
</ULDInformation>
- <BulkLoadInfo>
<CompartmentSection>5</CompartmentSection>
<LoadDestn>LHR</LoadDestn>
<LoadWt>30</LoadWt>
- <LoadCategory>
<LoadCategoryCode>BY</LoadCategoryCode>
</LoadCategory>
</BulkLoadInfo>
- <BulkLoadInfo>
<CompartmentSection>5</CompartmentSection>
<LoadDestn>LHR</LoadDestn>
<LoadWt>0</LoadWt>
- <LoadCategory>
<LoadCategoryCode>BT</LoadCategoryCode>
</LoadCategory>
</BulkLoadInfo>
- <BulkLoadInfo>
<CompartmentSection>5</CompartmentSection>
<LoadDestn>LHR</LoadDestn>
<LoadWt>0</LoadWt>
- <LoadCategory>
<LoadCategoryCode>BJ</LoadCategoryCode>
</LoadCategory>
</BulkLoadInfo>
- <BulkLoadInfo>
<CompartmentSection>5</CompartmentSection>
<LoadDestn>LHR</LoadDestn>
<LoadWt>0</LoadWt>
- <LoadCategory>
<LoadCategoryCode>BW</LoadCategoryCode>
</LoadCategory>
</BulkLoadInfo>
- <BulkLoadInfo>
<CompartmentSection>5</CompartmentSection>
<LoadDestn>LHR</LoadDestn>
<LoadWt>0</LoadWt>
- <LoadCategory>
<LoadCategoryCode>BBY</LoadCategoryCode>
</LoadCategory>
</BulkLoadInfo>
- <BulkLoadInfo>
<CompartmentSection>5</CompartmentSection>
<LoadDestn>LHR</LoadDestn>
<LoadWt>0</LoadWt>
- <LoadCategory>
<LoadCategoryCode>C</LoadCategoryCode>
</LoadCategory>
</BulkLoadInfo>
- <BulkLoadInfo>
<CompartmentSection>5</CompartmentSection>
<LoadDestn>LHR</LoadDestn>
<LoadWt>0</LoadWt>
- <LoadCategory>
<LoadCategoryCode>M</LoadCategoryCode>
</LoadCategory>
</BulkLoadInfo>
- <BulkLoadInfo>
<CompartmentSection>5</CompartmentSection>
<LoadDestn>LHR</LoadDestn>
<LoadWt>0</LoadWt>
- <LoadCategory>
<LoadCategoryCode>VEX</LoadCategoryCode>
</LoadCategory>
</BulkLoadInfo>
</DistribAndLoadInfo>
</CPM_MESSAGE>
</ErrorneousSourceMessage>
</ErrorInformation>
can anybody plz tell me how to fix this
regards
srinivas |
|
Back to top |
|
 |
jefflowrey |
Posted: Wed Jun 23, 2004 5:09 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
What have you done to try and solve this problem yourself? _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
Lisa |
Posted: Wed Jun 23, 2004 5:09 am Post subject: Database Problem |
|
|
Master
Joined: 07 Jun 2002 Posts: 287 Location: NJ
|
|
Back to top |
|
 |
k.srinivas |
Posted: Wed Jun 23, 2004 5:36 am Post subject: Re: Database Problem |
|
|
Apprentice
Joined: 16 May 2002 Posts: 29 Location: chennai
|
|
Back to top |
|
 |
|
|
 |
|
Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|
|