URGENT HELP needed - R3load failing for 53 packages

[symon_braunbaer]

Dear Experts,

I hope, that I am posting this question in the right section.

I we have an urgent problem - we are migrating a system from HP-UX/Oracle 11 to Windows Server 2012/MSSQL Server 2014.

Now we are running the import of the target system and SWPM is bringing up an error - I found out, that there are 53 packages,

failing for different reasons. I didn't check absolutely all of them, but I have a strong suspicion in SMIGR_CREATE_DDL, because

as far as I checked, all of them are objects, for which special statements have been created, using this report:

table /BI0/F0TCT_C22: Create overridden by ...DB/MSS/DFACT.SQL

And it is throwing an error like:

(DB) ERROR: DDL statement failed

(   CREATE TABLE ... )

Another error is:

Unknown object type 'BITMAP' used in CREATE, DROP, or ALTER statement.

I am sorry, but I can't paste anything! When I hit Ctrl+v, nothing happens! And I had huge problems till I managed to login here!

So, if anything more is needed, I may try to create a text file and attach it.

I have tried copying the files, generated by SMIGR_CREATE_DDL once again. I have also put the latest versions of R3load,

R3ldctl, R3szchk and R3ta, but unfortunately this error is still persisting and we're out of ideas now...

It is very disturbing, that I've tried to search for SAP notes and there seems to be one very good hit, although it speaks of Sybase

only, nothing about MSSQL Server.

Please kindly help us - this is very critical and we need to finish the import ASAP.

Many thanks in advance!

[ruidesousa · Accepted solution]

Hello Symon,

Did you confirm there were no inconsistencies reported on DB02 (Missing Tables and Indexes) before starting the OS/DB Migration?

Best regards

Rui

[symon_braunbaer · Accepted solution]

Hello Rui and many thanks for your reply!

There were inconsistencies, but nothing dangerous - tables MLICHECK~ and ORA_COCKPIT_HELPER, but never 53 objects and under no circumstances BI objects...

Thanks!

[ruidesousa · Accepted solution]

Hi Symon,

I see. Is there any way you can post the error logs from one or two packages to have a better understanding?

Best regards

Rui

[symon_braunbaer · Accepted solution]

Sure. I don't know if I will make it today, but I will do it for sure!

[ruidesousa · Accepted solution]

Not a problem Symon, let me know if you have any issues posting the package logs In the meantime, just for confirmation, you are not performing a Unicode Conversion also are you?

[symon_braunbaer · Accepted solution]

[symon_braunbaer · Accepted solution]

Sorry, I know that it's a very idiotic way to post an error message, but I didn't find a way to attach a text file and I simply can't paste !! Don't know what's wrong with SAP's webpages these days!! Also when searching for SAP notes on the marketplace, no matter what I search for, I always find 0 SAP notes !!! Thank you!

[ruidesousa · Accepted solution]

Hi Symon,

Not a problem, it serves the purpose

Can you confirm if your Source System is on Unicode?

Also, have you checked the cluster and pool tables before starting?

Weird issue regarding the SAP webpages, have you tried with a different browser to see if the outcome is the same?

[symon_braunbaer · Accepted solution]

Hello,

in the end I've solved the problem, but after a lot of thinking (it was almost smelling, like something is burning 🙂 )

Regarding the SAP webpages - yes, I tried both Firefox and IE - no matter what I search for, it always returns 0 SAP notes... Cheers for the new design !!!

[ruidesousa · Accepted solution]

Hi Symon,

That's great, hope to have helped in some way

Best regards

Rui