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

SQL 2005 SAP R/3 4.6C - DBSL error RC=99 on import of Basis 4.6C SP 39

Hi,

I have just built a R/3 4.6C system on SQL 2005 with 4.6D_EXT kernel. The build was done using R3load to export from the 4.6C/SQL 2000/32bit system and import to 4.6C/SQL 2005/64bit system. The source 4.6C system only had Basis support package 37 applied, and I am trying to apply Basis 4.6C 38-57 on the 4.6C/SQL 2005/64bit system (in preparation for an ECC6 upgrade) and I get the following error:

EXEC SQL: SELECT ID,OBJECT,LANGU,TYP,VERSION FROM DOKIL WHERE (LANGU IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,

[developertra,00000] ExecuteAndFlush return code: 0x80040e10 Stmt: [CREATE PROCEDURE ##Y8IBASAPDEIBD00000025600000000006164133 @P

99972 0.099972

[developertra,00000] MapHr:80040E10 DB_E_PARAMNOTOPTIONAL 43 0.100015

[developertra,00000] HandleOledbError [ExecuteAndFlush,line 33423]: Error/Message: (err 0, sev 0), No value given for one or more

96 0.100111

[developertra,00000] DbSlPrepare - Error 99 (dbcode -2147217904) on proc. creation

56 0.100167

[developertra,00000] DbSlPrepare - <CREATE PROCEDURE ##Y8IBASAPDEIBD00000025600000000006164133 @P000 varchar(3072) = ' ', @P001 v

105 0.100272

[developertra,00000] 1 times error (0,0) in sequence 30 0.100302

[developertra,00000] dbdsmss: DBSL99 SQL0 27 0.100329

[developertra,00000] No value given for one or more required parameters.

62 0.100391

[dbds ,00589] ***LOG BY2=>sql error 0 performing FET

66 0.100457

[dbds ,00589] ***LOG BY0=>No value given for one or more required parameters.

I have checked the collation setting in SQL 2005 and it is:

select serverproperty('collation')

SQL_Latin1_General_CP850_BIN2

There are 97000 odd entries in DOKIL, so I don't think that is the problem.

Would appreciate any assistance.

Kind regards,

Sheryl.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 07:07 AM

    Hi ,

    Instead of doing the build with export import, you can try to do the same with backup restore,,

    But remember your sql2000 should be on bin2... then you can take backup and restore.

    Since it is from 2000 to 2005 the restore would happen and it will work fine.

    Try this and check out, since the error you have pasted is not clearly giving any picture...

    Regards,

    Ravi.

    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.