Skip to Content
author's profile photo Former Member
Former Member

Error getting the table form SQLdatabase

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Sep 19, 2007 at 07:07 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 09:47 PM

    Thank you

    as it turns out is was user access in SQL database.

    some points were awarded for attempt

    regards

    Patrick

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.