on 09-11-2007 5:52 AM
Hi
I am trying to get the table form database. Connection is fine but when i am trying to display tables:
C Thread ID:6388
C dbmssslib.dll patch info
C patchlevel 0
C patchno 72
C patchcomment MSSQL: Thread check in DbSlDisconnect (969143)
C Network connection used from ACDBD006 to 10.8.191.80 using tcp:10.8.191.80
C Connected to db server : [10.8.191.80] server_used : [tcp:10.8.191.80], dbname: Procurement_Test, dbuser: dbo
C pn_id:10.8.191.80_PROCUREMENT_TEST_BWD
B Connection 6 opened (DBSL handle 1)
B Wp Hdl ConName ConId ConState TX PRM RCT TIM MAX OPT Date Time DBHost
B 000 000 R/3 000000000 ACTIVE NO YES NO 000 255 255 20070830 111230 ACDBD006
B 000 001 R/3* 000000023 DISCONNECTED NO NO NO 000 255 255 20070907 132307 ACDBD006
B 000 002 R/3*BWMON 000000021 DISCONNECTED NO NO NO 003 255 255 20070907 130541 ACDBD006
B 000 003 R/3*DTPLOG 000000022 DISCONNECTED NO NO NO 000 255 255 20070907 131807 ACDBD006
B 000 004 TEST 000000044 DISCONNECTED NO NO NO 004 100 005 20070911 105027 10.8.191.80
B 000 005 ACSCT001 000000042 DISCONNECTED NO NO NO 000 100 005 20070910 132555
B 000 006 BUYIT_CONN 000000110 ACTIVE NO YES NO 004 100 100 20070911 143721 10.8.191.80
C DbSlBegRead[1]: ##Y4ACDBD006Procurement_Test00000011640000000001143721
C DbSlBegRead[1]: ##Y4ACDBD006Procurement_Test00000011640000000002143721
B Tue Sep 11 14:38:16 2007
B 6: name = BUYIT_CONN, con_id = 000000110 state = INACTIVE , perm = YES, reco = NO , timeout = 004, con_max = 100, con_opt = 10
B 6: name = BUYIT_CONN, con_id = 000000110 state = INACTIVE , perm = YES, reco = NO , timeout = 003, con_max = 100, con_opt = 10
C DbSlBegRead[1]: ##Y4ACDBD006bwd00000011640000000017111230
C ParamStmtExec: line 13049. hr: 0x80040e2f The statement has been terminated.
C<b> DbSlModify - Error 26 (dbcode 2627)
C No statement!</b>
C ParamStmtExec: line 13049. hr: 0x80040e2f The statement has been terminated.
C <b>DbSlModify - Error 26 (dbcode 2627)
C No statement!</b>
C DbSlBegRead[1]: ##Y4ACDBD006bwd00000011640000131213111230
C DbSlBegRead[1]: ##Y4ACDBD006bwd00000011640000131213111230
C DbSlBegRead[1]: ##Y4ACDBD006bwd00000011640000000709111230
C DbSlBegRead[1]: ##Y4ACDBD006bwd00000070720000000061111230
Hi
try this
F fact tables are
created without a unique index. However, existing unique indexes are not
deleted. This may sometimes cause a duplicate key during loading to the
InfoCube and thus trigger the above-described short dump.
Run the report SAP_DROP_UNIQUE_FACTINDEX_DB2 to replace the unique index on F fact tables with a non-unique index. Refer also to note 511170.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you
as it turns out is was user access in SQL database.
some points were awarded for attempt
regards
Patrick
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.