on 07-03-2014 8:45 AM
Hello,
Heterogeneous system copy from AIX Oracle to Windows MSSQL ended with error code 103.
NW: 702
Kernel 720_REL 114
export_monitor.log and SAPAPPL1.log displays ,
OS error message: No space left on device.
Export Data used almost 210GB left in the device.
Total size of db is around 500 GB and I was expecting the export to be around 50-60 GB
There has been 155 file each with 1 GB created for SAPAPPL1.001 ,
SAPAPPL1.002
SAPAPPL1.003.... SAPAPPL1.155
Did I missed anything while starting the export or this is usual for Heterogeneous migration ?
Please help .
Regards,
Raghu
Hello Unnikrishnan,
So far I have done only done the Export.
I have followed the System Copy Guide based on the Application Server ABAP of SAP Netweaver on Unix , Using the Software Provisioning Manager 1.0.
Please make sure you have enough space in the Disk where you are copying the Export. It took 220GB for me.
Might come up with error ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP. Make sure PSAPTEMP has atleast 40GB.
I would prefer to continue with Unsorted Unload. Because when I tried with Sorted it was ending with error. By Default it will be selected if its AIX platform. Please refer NOTE 954268
Regards,
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
I was getting error while continueing with the export .
ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP.
Increased the TEMP space and continued . And it worked .
But its same . It took around 17 hours and space is 217GB.
Thanks you all for supporting.
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Yves,
I just tried with DDL statement and it created a SQL file . You were mentioning about if its not BW system it will not generate any file . I just gone through the Guide , it was not clear though . and it generated SQL file with only 1KB .
Export is still running and its around 60GB so far. still got 4 more to complete.
I was not able to update R3 files this time . If this export fails or any issue , surely I will try with that option too.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you all for your suggestions.
Yes , I am planning to update the R3* files and continue with the export again . I will update once it is finished.
Regards
Raghu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Your true the export size is unusually big but this might be because of the 'endianess' change that comes with the move from Aix to Intel platform.
552464 - What is Big Endian / Little Endian? What Endian do I have?
Best regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your support .
Well , the only thing I have missed it running the DDL script. Not sure if that made this difference. Anyways I am going to give another try with generating DLL statement.
I will update the status if it is coming up with similar size or any changes to the export.
Thanks
The DDL script (SMIGR_CREATE_DDL) should not change anything to export size.
If you are not on a BW system it should not generate any file.
771209 - NetWeaver 04: System copy (supplementary note)
Start the SMIGR_CREATE_DDL program before you export the data from the source system. This program allows you to copy database objects that do not correspond to SAP standards. These objects include partitioned (fragmented) tables and bitmap indexes.
Regards
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.