Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi guys
I have a question. I am in front of the end of the downtime phase of SCM7 upgrade. I am at the step where it ask me to run the report "/SAPAPO/OM_LC_UPGRADE_70" and perform the steps from section "C" (livecache optimizer upgrade). The first button is called "Logging Off, Start liveCache" when I press on this button the system dumps , creates short dump.
"DBIF_DSQL2_SQL_ERROR"
What happened?
The error "-10401" occurred in the current database connection "LCA".
How to correct the error
Database error text........: "Conversion of parameter/column (1) would truncate
data"
Database error code........: "-10401"
Triggering SQL statement...: "EXECUTE PROCEDURE "APS_PLAN_VERS_GET_ALL""
Internal call code.........: "[DBDS/NEW DSQL]"
Please check the entries in the system log (Transaction SM21).
"DBIF_DSQL2_SQL_ERROR" "CX_SY_NATIVE_SQL_ERROR"
"/SAPAPO/SAPLOM_CORE" or "/SAPAPO/LOM_COREU17"
"/SAPAPO/OM_PLAN_VERS_GET_ALL"...
I still can't find the reason why it's dumping? There is no errors or anything more in the dev_w* logs or in the other logs. there is simply nothing in the logs of livecache. I was thinking... maybe I forgot to apply some note before the upgrade as a prerequisite?Seems like program issue? maybe there some note that has to apply to care out the fixes in the program?
This is from dev_w*:
C *** ERROR => execute() of C_0013, #rec=0, rc=1, rcSQL=-10401 (Conversion of parameter/column (1) would truncate data)
[dbsdbsql.cpp 1714]
C *** ERROR => EXECUTE on connection 1, rc=-10401 (Conversion of parameter/column (1) would truncate data)
[dbdssdb.cpp 2172]
C sc_p=0x6000000004a5b448,no=13,idc_p=(nil),con=1,ac t=1,slen=45,smax=256,#vars=0,stmt=0x6000000004d7871 0,table= "APS_PLAN_VERS_GET_ALL"
C CALL USER."APS_PLAN_VERS_GET_ALL" ( ?, ?, ? );
C *** ERROR => dbdssdb: SQL Error -10401, Message: Conversion of parameter/column (1) would truncate data
[dbdssdb.cpp 2408]
B ***LOG BY2=> sql error -10401 performing EXE [dbds#2 @ 364] [dbds 0364 ]
B ***LOG BY0=> Conversion of parameter/column (1) would truncate data [dbds#2 @ 364] [dbds 0364 ]
I will appreciate all the inputs!
Thanks
Vladi
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| | Most Popular White Papers
In the Spotlight  _.____.__ |
