on 08-05-2011 6:16 PM
Dear Gurus,
I did Offline DB Restore for our ECC6.0 system ,We have DB2 as databse and AIX 5.3 as OS.
Restore went successfully.Then i restarted SAP system but SAPGUI is not coming up.When i checked at OS level i can see work process waiting via DPMON.Archiving is disabled in our system.When i checked Workprocess trace it seems to be code page issue.Below is the Workprocess W0 trace
D *** ERROR => .------------------------------============----------------------------. [diagconv.c 103]
D *** ERROR => | RSCP - Error | [diagconv.c 103]
D *** ERROR => | Error from: Codepage handling (RSCP) | [diagconv.c 103]
D *** ERROR => | code: 2048 RSCPENOCONV Wanted conversion not available. | [diagconv.c 103]
D *** ERROR => | unsupported table/NLS codepages pair | [diagconv.c 103]
D *** ERROR => | module: rscpc no: 68 line: 11600 T100: TS012 | [diagconv.c 103]
D *** ERROR => | TSL01: F38 p3: unknownMeth p4: & -> & | [diagconv.c 103]
D *** ERROR => |----------------------------------------------------------------------| [diagconv.c 103]
D *** ERROR => | Some SQL information, which may or may not belong to this error: | [diagconv.c 103]
D *** ERROR => | SQL error code -1585 | [diagconv.c 103]
D *** ERROR => | SQL1585N A system temporary table space with sufficient page size d | [diagconv.c 103]
D *** ERROR => |----------------------------------------------------------------------| [diagconv.c 103]
D *** ERROR => | Impromptu CCC initialization by rscpCInit | [diagconv.c 103]
D *** ERROR => `----------------------------------------------------------------------' [diagconv.c 103]
D *** ERROR => user : DiagOConvert RC 2048 [diagconv.c 1467]
Also W0 trace also contains
ABAP Program SAPLSPRI .
A Source LSPRIF10 Line 31.
A Error Code CONVERSION_CODEPAGE_UNKNOWN.
A Module $Id: //bas/700_REL/src/krn/runt/abconcnv.c#1 $ SAP.
A Function ab_ImportTrhd Line 1108.
A ** RABAX: level LEV_RX_STDERR completed.
A ** RABAX: level LEV_RX_RFC_ERROR entered.
A ** RABAX: level LEV_RX_RFC_ERROR completed.
A ** RABAX: level LEV_RX_RFC_CLOSE entered.
A ** RABAX: level LEV_RX_RFC_CLOSE completed.
A ** RABAX: level LEV_RX_IMC_ERROR entered.
A ** RABAX: level LEV_RX_IMC_ERROR completed.
A ** RABAX: level LEV_RX_DATASET_CLOSE entered.
A ** RABAX: level LEV_RX_DATASET_CLOSE completed.
A ** RABAX: level LEV_RX_ERROR_SAVE entered.
A ** RABAX: level LEV_RX_ERROR_SAVE completed.
A ** RABAX: level LEV_RX_ERROR_TPDA entered.
A ** RABAX: level LEV_RX_ERROR_TPDA completed.
A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI entered.
A ** RABAX: level LEV_RX_PXA_RELEASE_RUDI completed.
A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP entered.
A ** RABAX: level LEV_RX_LIVE_CACHE_CLEANUP completed.
A ** RABAX: level LEV_RX_END entered.
A ** RABAX: level LEV_RX_END completed.
A ** RABAX: end no http/smtp
A ** RABAX: end RX_BTCHLOG|RX_VBLOG
A Unable to convert from code page '4102' to code page '4102'..
A
Kindly suggest
Regards
Kuldeep Singh
Hello
Thanks Sri and Ken for your guidence.It was problem with Temporary tablespace.I deleted and created new one.Now system is fine.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kuldeep
SQL1585N A system temporary table space with sufficient page size does
not exist
Please see the following note:
617438 - DB6: SQL1585N during the execution of an SQL Statement
Regards
Ken
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kuldeep,
Not able to exactly figure out the issue but few things to check:
- SQL1585N A system temporary table space with sufficient page size
Hints memory related issue. Please ensure the page file size is sufficient.
- Check if the compatible and latest kernel release for your hardware is in the system.
- Check if profile parameter install/codepage/appl_server is set to the correct value.
Regards,
Srikishan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.