Datastage Server 7.5.1A migration issue to 7.5.3
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
Datastage Server 7.5.1A migration issue to 7.5.3
HI I recently upgrade the Datastage server fronm 7.5.1A to 7.5.3 .
everything work fine except the following .
while i am using the DRS stage to connect to the database ( SQL server 2000)
Project:tmnt_uat(prxetl1)
Job name:jbPjS_I06_CLR_Dept
Event #:69
Timestamp:30/06/2008 13:58:37
Event type:Fatal
User: dsadm
Message:
main_program: Fatal Error: Fatal: Shared library (drsenu.so) failed to load: errno = (8), system message = (rtld: 0712-001 Symbol DSPIMallocStageName was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCRegisterPassive was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol ds_writelog was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCLoadResourceEx was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCDeclareProperty was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCPropDefaultFromStr was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCUVValueMark was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
Additional errors occurred but are not reported.)
Could you please provide me the solution.
everything work fine except the following .
while i am using the DRS stage to connect to the database ( SQL server 2000)
Project:tmnt_uat(prxetl1)
Job name:jbPjS_I06_CLR_Dept
Event #:69
Timestamp:30/06/2008 13:58:37
Event type:Fatal
User: dsadm
Message:
main_program: Fatal Error: Fatal: Shared library (drsenu.so) failed to load: errno = (8), system message = (rtld: 0712-001 Symbol DSPIMallocStageName was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCRegisterPassive was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol ds_writelog was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCLoadResourceEx was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCDeclareProperty was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCPropDefaultFromStr was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
rtld: 0712-001 Symbol DSCUVValueMark was referenced
from module /home/dsadm/Ascential/DataStage/DSEngine/lib/drsenu.so(), but a runtime definition
of the symbol was not found.
Additional errors occurred but are not reported.)
Could you please provide me the solution.
regards
sunayan
sunayan
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
hi All ,
Got one more error while using the DRS stage.
not sure why it is happening.
APT_CombinedOperatorController,0: Fatal Error: Fatal: [DataDirect][ODBC lib] Function sequence error
SQLNumResultCols: Error retrieveing columns in the result set
Plug-in stage property (WHERE_CLAUSE) is not defined for Input Links
node_node1: combination of 3 operators [odSchedule_Data; APT_TransformOperatorImplV0S133_jbHRP_I02_UPD_00_BkupTable_xFMT in xFMT; odSchedule_Data_Bkup], partition 0 of 1, processID 376,904 on node1, player 1 terminated unexpectedly.
Any clue how to resolve
Got one more error while using the DRS stage.
not sure why it is happening.
APT_CombinedOperatorController,0: Fatal Error: Fatal: [DataDirect][ODBC lib] Function sequence error
SQLNumResultCols: Error retrieveing columns in the result set
Plug-in stage property (WHERE_CLAUSE) is not defined for Input Links
node_node1: combination of 3 operators [odSchedule_Data; APT_TransformOperatorImplV0S133_jbHRP_I02_UPD_00_BkupTable_xFMT in xFMT; odSchedule_Data_Bkup], partition 0 of 1, processID 376,904 on node1, player 1 terminated unexpectedly.
Any clue how to resolve
regards
sunayan
sunayan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
Hi Ray,
I run it with the Enviornment variable
I got the following error:
drsCLR_UKCUSTOM_CUSTOM_DRIVERS,0: Failure during execution of operator logic.
drsCLR_UKCUSTOM_CUSTOM_DRIVERS,0: Fatal Error: Fatal: The 0 column(s) defined on this link do not match the 0 column result set generated by the SQL statement: %3.
Plug-in stage property (WHERE_CLAUSE) is not defined for Input Links
node_node1: operator [drsCLR_UKCUSTOM_CUSTOM_DRIVERS], partition 0 of 1, processID 733,290 on node1, player 3 terminated unexpectedly.
main_program: Unexpected exit status 1
main_program: Step execution finished with status = FAILED.
I run it with the Enviornment variable
I got the following error:
drsCLR_UKCUSTOM_CUSTOM_DRIVERS,0: Failure during execution of operator logic.
drsCLR_UKCUSTOM_CUSTOM_DRIVERS,0: Fatal Error: Fatal: The 0 column(s) defined on this link do not match the 0 column result set generated by the SQL statement: %3.
Plug-in stage property (WHERE_CLAUSE) is not defined for Input Links
node_node1: operator [drsCLR_UKCUSTOM_CUSTOM_DRIVERS], partition 0 of 1, processID 733,290 on node1, player 3 terminated unexpectedly.
main_program: Unexpected exit status 1
main_program: Step execution finished with status = FAILED.
regards
sunayan
sunayan
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have no columns defined on the input link.
But you have one parameter marker in the SQL.
This is not a correct combination, which is what the error message is telling you.
But you have one parameter marker in the SQL.
This is not a correct combination, which is what the error message is telling you.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
Hi Ray,ray.wurlod wrote:You have no columns defined on the input link.
But you have one parameter marker in the SQL.
This is not a correct combination, which is what the error message is telling you. ...
the same piece of code was working fine in the version 7.5.1a but not in 7.5.3
i had contact to IBM . they had intimated that a patch need to be insstalled for this.
regards
sunayan
sunayan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You were relying on something that did not work properly, and has now been fixed. The patch will un-fix it, so that previous behaviour can resume. A better solution would be to get the logic of the job design correct.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
Hi ,
Initially the job logic was DRS at the target side and was unable to execute the before and after SQL.
Since it was a staging table and the only objective was to truncate / delete as per the business area.
now i use it in the source end and use the logic.
while reading the data from the table a where clause with condition 1=0
and then an after SQL doing the same ( truncate / delete ) the table.
this is an alternative of the job design.
Initially the job logic was DRS at the target side and was unable to execute the before and after SQL.
Since it was a staging table and the only objective was to truncate / delete as per the business area.
now i use it in the source end and use the logic.
while reading the data from the table a where clause with condition 1=0
and then an after SQL doing the same ( truncate / delete ) the table.
this is an alternative of the job design.
regards
sunayan
sunayan
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata