Java Export hangs at 'Export Java Database Content' phase

[Former Member]

Hi All -

As part of system refresh activities,we are doing Java Export from our Production system(PE1) & we will use that export to import it in our Qulaity system(QE1).So while doing Java Export,the export gets stucks/hangs at 'Export Java Database Content" phase which is the last phase in Java Export steps.We have been doing this task since many years & we did not encounter this kind of issue ever.There are no errors or at least warnings in the logs like sapinst_dev.log,jload.log,jload.java.log,sapinst.log etc.Our environment details are as below

EP -6.0

OS - AIX 5.3,64 BIT

DB - DB2 UDB

SAPINST version - 642

Java version is below

pe1adm> java -fullversion

java full version "J2RE 1.4.2 IBM AIX 5L for PowerPC (64 bit JVM) build caix64142ifx-20100918 (SR13 FP6)"

Please note with the SAPINST we are using currently, the exports of remaining systems in EP & other solutions like ECC,CR,SRM,XI,BI are successfull.We are having this issue only in PE1.Looks like some bug in code.So request the experts in this forum to please take a look at it & provide me with solution if any of you have faced the similar situation.

Thanks & regards,

Nagendra.

[former_member185031]

What sapinst is trying to do in the backend ? what i meant is you will have to see what table or object it is trying to export while it hangs ?

Regards,

Subhash

[Former Member]

Thank you for your reply Subhash.The below is the last entry in jload.log.It is at EP_ATTR_HEADERS.While doing the Java export,we asked our DBA to monitor to find out any errors at DB side.He monitored and said that no deadlocks or no infinite loops are found.Also he said that he cannot create index for that too because it is trying to do select *.In our first 2 or 3 attempts it used to hang at CA_PRODUCTS meta data exported,CA_PROPERTY meta data exported.Now here.Our DBA said that EP_ATTR_HEADERS has 1.4M rows.We tried to bounce the entire system also,but no luck.We have the same issue.Peculiar thing is we dont see any errors or warnings in the logs.

23.06.11 09:54:21 com.sap.inst.jload.Jload dbExport

INFO: EP_ATTR_DEFS exported (6 rows)

23.06.11 09:54:21 com.sap.inst.jload.Jload dbExport

INFO: EP_ATTR_HEADERS meta data exported

Please let me know if you need any further info in resolving this issue.

Thanks & regards,

Nagendra.

[former_member185031]

Can you please validate this Parameter has been set which is given on this thread.

Regards,

Subhash

[Former Member]

Yes Subhash..the parameter does exist in our PE1 Instance profile(PE1_JC00_pe1ci).The parameter is as below.This is the first time we faced this issue.For around 5 years we did not encounter this issue

SAPLOCALHOST = pe1ci

Looking forward for your further help.

Thanks & regards,

Nagendra

[former_member185031]

Hello Nagendra,

Please refer to this thread. I have no idea rather then this given that it might be a java issue also. I gues you have to open a OSS call or let's wait if anyone else can suggest something else.

Regards,

Subhash

[Former Member]

Subhash...As per the thread you sent, looks like they are suggesting to go 1.4.2_12 & above.We are at SR13 now.So we are higher level than mentioned in the other thread provided by you.So we should be good.

pe1adm> java -fullversion

java full version "J2RE 1.4.2 IBM AIX 5L for PowerPC (64 bit JVM) build caix64142ifx-20100918 (SR13 FP6)"

We did open a SAP Customer message,but we are not getting proper response on that.So thought somebody in this forum would have experienced the same issue & shed some light on this.Anyways will wait if somebody else has some solution for this.

Thanks for looking into it.

Regards,

Nagendra.

[Former Member]

Does anybody has any update on this issue please?Request the experts to look into it & provide the solution.

Thanks,

Nagendra.