| Author |
Message
|
| WMB_GUY |
 Posted: Fri Jun 27, 2008 5:36 am Post subject: rollback transaction issue |
 |
|
Newbie
Joined: 27 Jun 2008
Posts: 5
|
Hi
I am calling sybase SP(stored procedure) from my flow. Before calling SP i m executing the following line of code.
PASSTHRU 'set ansinull off' TO Database.{DataSource};
PASSTHRU 'rollback transaction' TO Database.{DataSource};
first line is executing successfully in windows as well as in Unix environment. but second line is throwing exception in UNIX. Its running properly in Windows.
here is the trace for error:
(
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbDat
aFlowNode.cpp'
(0x03000000):Line = 616
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'MainFlow#FCMComposite_1_3'
(0x03000000):Label = 'MainFlow.CALL_SYBASE_STORED_PRO
CEDURE'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Node throwing exception'
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbRdl/
ImbRdlStatementGroup.cpp'
(0x03000000):Line = 573
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'MainFlow#FCMComposite_1_3'
(0x03000000):Label = 'MainFlow.CALL_SYBASE_STORED_PROC
EDURE'
"try3.log" 78 lines, 3423 characters
(
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbDataFlowNode.cpp'
(0x03000000):Line = 616
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'MainFlow#FCMComposite_1_3'
(0x03000000):Label = 'MainFlow.CALL_SYBASE_STORED_PROCEDURE'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Node throwing exception'
(0x01000000):RecoverableException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp'
(0x03000000):Line = 573
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'MainFlow#FCMComposite_1_3'
(0x03000000):Label = 'MainFlow.CALL_SYBASE_STORED_PROCEDURE'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2488
(0x03000000):Text = 'Error detected, rethrowing'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.Call_Syabse_Stored_Procdure_Compute.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '6.4'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'PASSTHRU('rollback transaction')'
)
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x03000000):Line = 227
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2321
(0x03000000):Text = 'Root SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '-1'
)
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x03000000):Line = 355
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x01000000):DatabaseException = (
(0x03000000):File = '/build/S600_P/src/DataFlowEngine/ImbOdbc.cpp'
(0x03000000):Line = 355
(0x03000000):Function = 'ImbOdbcHandle::checkRcInner'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2322
(0x03000000):Text = 'Child SQL exception'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '40001'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '0'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '[DataDirect][ODBC Sybase Wire Protocol driver]1340'
)
)
)
)
Is this any driver configuration issue?
the driver entry in ODBC.ini on unix is
[DSNNAME]
Driver=/opt/IBM/mqsi/6.0/merant/lib/UKase20.so
Description=DataDirect 5.0 Sybase Wire Protocol
Database=<abcd>
ServerName=<servername>
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=<network address>
SelectUserName=1
please help me out. |
|
| Back to top |
|
 |
| WMB_GUY |
| Posted: Tue Jul 01, 2008 4:10 am Post subject: |
|
|
Newbie
Joined: 27 Jun 2008
Posts: 5
|
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Jul 01, 2008 4:16 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
I am not sure...how this works at backend side....
'PASSTHRU('rollback transaction')'
does this works at DB side...
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| WMB_GUY |
| Posted: Tue Jul 01, 2008 11:17 pm Post subject: |
|
|
Newbie
Joined: 27 Jun 2008
Posts: 5
|
| yes. In window its working but in UNIX its throwing an exception. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Tue Jul 01, 2008 11:32 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
so unix thats the exact command
talk to your DBA and find out the exact command supposed to be executed on unix platform.
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| WMB_GUY |
| Posted: Wed Jul 02, 2008 12:19 am Post subject: |
|
|
Newbie
Joined: 27 Jun 2008
Posts: 5
|
They have no idea what's wrong with this commnad in UNIX and what should be passed from message broker side.
bcoz the same thing is working in windows. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Jul 02, 2008 1:46 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
you have to test directly on database.
try out whether those SQL commands work successfully on DB side
once it ready then you can call through PASSTHRU
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| WMB_GUY |
| Posted: Wed Jul 02, 2008 2:20 am Post subject: |
|
|
Newbie
Joined: 27 Jun 2008
Posts: 5
|
| but why its working on windows. |
|
| Back to top |
|
|
| Gaya3 |
| Posted: Wed Jul 02, 2008 2:26 am Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
some of the SQL commands (WINDOWS) wont work as expected on UNIX.
thats the reason telling you to test it once...
as passthru directly takes those commands to DB for executing with out validating.
so test those SQL command first...then get back to us
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
|
|
