on 02-20-2013 8:34 PM
Dear all,
we would like to use PAL functions. The wrapper procedure has been created and tested successfully by calling it with the SYSTEM user, as described in hana_dev_pal_en document.
But now we see the following error message, by calling:
call SYSTEM.afl_wrapper_generator
Could not execute 'call SYSTEM.afl_wrapper_generator('PAL_ANOMALY_DETECTION', 'AFLPAL', 'ANOMALYDETECTION', PDATA)' in 55 ms 674 µs . SAP DBTech JDBC: [423]: liveCache error: [423] SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1711): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace
Has had anyone similar problems?
Thanks a lot!
Cheers
Alexander
Alexander,
Test this construction :
call SYSTEM.afl_wrapper_generator ('PAL_ANOMALY_DETECTION1', 'AFLPAL', 'ANOMALYDETECTION', PDATA)
and check PDATA(only distinct values in it)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
I am also getting the same error like
SAP DBTech JDBC: [423]: liveCache error: [423] SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1711): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace
I have executed the below statement.
call SYSTEM.afl_wrapper_generator('PAL_DBSCAN9', 'AFLPAL', 'DBSCAN', PAL_DBSCAN_PDATA_TBL);
I have checked in _SYS_AFL also there is no PAL_DBSCAN9 procedure .
If it is duplicate i got the error for 'PAL_ANOMALY_DETECTION' If I am trying to re run the procedure again as it should be unique. But in the first time only I am facing the problem . I successfully executed the 'PAL_ANOMALY_DETECTION'.
Please help me how to resolve this issue.
Thanks & Regards,
Ramana.
Hi Venkata
Please refer your thread http://scn.sap.com/thread/3410048 and refer the videos which will explain the same error as it is discussed here.
PAL: Troubleshooting | SAP HANA
Regards
Kumar
Hi Dmitry,
exactly this is the problem - our PDATA parameter was a time series with distinct date values and integer sales amount values. PAL has a restrictive parameterization policy.
For all having the same problem: check first column is a distinct INT ID (mandatorily a primary key). Unfortunately this limits us by not being able to use local temporary tables....
Cheers
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
As Alexander has mentioned, I am also getting the same error...!!!
Could not execute 'CALL SYSTEM.AFL_WRAPPER_GENERATOR ('PAL_TS_S', 'AFLPAL', 'SINGLESMOOTH', PAL_TS_SIGNATURE)' in 252 ms 106 µs . SAP DBTech JDBC: [423]: liveCache error: [423] SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1472): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace
Please Help ..
Regards
Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi selvan ,
Yes I have already executed the
afl_wrapper_generator.sql
script file, and in the same session with different SQL script window when I try to leverage PAL then i am getting the error...!!
Could not execute 'CALL SYSTEM.AFL_WRAPPER_GENERATOR ('PAL_TS_S', 'AFLPAL', 'SINGLESMOOTH', PAL_TS_SIGNATURE)' in 252 ms 106 µs . SAP DBTech JDBC: [423]: liveCache error: [423] SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1472): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace
Regards
Kumar.
Hi Alexander,
what does the indexserver trace file has to say about this?
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars,
here the relevant trace:
[56197]{242986}[-2378730] 2013-02-19 00:41:42.254498 i TraceContext TraceContext.cpp(00445) : UserName=SYSTEM, ApplicationName=HDBStudio
[56197]{242986}[-2378730] 2013-02-19 00:41:42.254446 e AFLPM_SQL AFLPM_SQLDriverObj.cpp(01962) : Registration of AFLLANG wrapper PAL_LINEAR_TEST failed at describeFunction with error: invalid parameter description!
[56197]{242986}[-2378730] 2013-02-19 00:41:42.255742 e LJIT cePopCustomLjit.cpp(00596) : Llang Runtime Error: Exception::SQLException423: liveCache error: registration finished with errors, see indexserver trace
at main (line 223) (SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1711))
[56197]{242986}[-2378730] 2013-02-19 00:41:42.255758 e LJIT cePopCustomLjit.cpp(00612) : SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1711): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace
[51436]{242986}[-2378730] 2013-02-19 00:41:42.255948 i TraceContext TraceContext.cpp(00445) : UserName=SYSTEM, ApplicationName=HDBStudio
[51436]{242986}[-2378730] 2013-02-19 00:41:42.255924 e Executor PlanExecutor.cpp(00219) : plan plan217315@hana-2:30503 failed with rc 423; SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1711): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace
[51436]{242986}[-2378730] 2013-02-19 00:41:42.255960 e Executor PlanExecutor.cpp(00219) : -- returns for plan217315@hana-2:30503:
[51436]{242986}[-2378730] 2013-02-19 00:41:42.255968 e Executor PlanExecutor.cpp(00219) : pop=pop1, class="ceSqlPop", duration=00:41:40.479 +0.003, MemAllocBytes=0, MemDeallocBytes=0, CacheLikeMemAllocBytes=0, CacheLikeMemDeallocBytes=0, rc=0
[51436]{242986}[-2378730] 2013-02-19 00:41:42.255986 e Executor PlanExecutor.cpp(00219) : pop=pop2, class="ceConvertDatatypePop", duration=00:41:40.483 +0.000, MemAllocBytes=0, MemDeallocBytes=0, CacheLikeMemAllocBytes=0, CacheLikeMemDeallocBytes=0, rc=0
[51436]{242986}[-2378730] 2013-02-19 00:41:42.255993 e Executor PlanExecutor.cpp(00219) : pop=pop3, class="ceLjitPop", location=hana-2:30503, duration=00:41:40.483 +0.239, MemAllocBytes=0, MemDeallocBytes=0, CacheLikeMemAllocBytes=0, CacheLikeMemDeallocBytes=0, rc=423, msg=SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1711): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256002 e Executor PlanExecutor.cpp(00219) : pop=<all>, duration=00:41:40.479 to 00:41:40.722 +0.243
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256008 e Executor PlanExecutor.cpp(00219) : con=a, class="ceDataSet", size=444
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256012 e Executor PlanExecutor.cpp(00219) : con=b, class="ceDataSet", size=444
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256015 e Executor PlanExecutor.cpp(00219) : con=c, class="ceDataSet", size=0
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256017 e Executor PlanExecutor.cpp(00219) : con=f, class="ceDataSet", size=0
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256020 e Executor PlanExecutor.cpp(00219) : con=<all>, duration=+0.000
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256027 e Executor PlanExecutor.cpp(00219) : -- end executor returns
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256031 e Executor PlanExecutor.cpp(00219) : pop3 (rc 423, SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1711): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace)
pop = executorPy.ceLjitPop() # pop3
pi = fuzzypy.CePlanInput()
#pragma function "SYSTEM.AFL_WRAPPER_GENERATOR"
export Void main(NullString "PROC" sPROC, NullString "AREA" sAREA, NullString "AFL" sAFL, Table<Int32 "ID", NullString "TYPENAME", NullString "DIRECTION"> "DATA" vDATA, Table<FixedString<1> "DUMMY"> & dummy)
{
Connection conn;
RSHeap heap = RSHeap(conn);
RSEnv env = RSEnv(heap);
Int32 ucnt = 0;
// scalar input parameter: PROC
RSString vPROC = RSString(sPROC);
// scalar input parameter: AREA
RSString vAREA = RSString(sAREA);
// scalar input parameter: AFL
RSString vAFL = RSString(sAFL);
TemporaryTableHandle tabDATA = TemporaryTableHandle(vDATA); // input table variable
RSString vV_SCHEMA_NAME; // V_SCHEMA_NAME_1: intermediate def-variable
RSString vV_TABLE_NAME; // V_TABLE_NAME_1: intermediate def-variable
RSString vV_STRING; // V_STRING_1: intermediate def-variable
RSString vV_STRING___2; // V_STRING_2: intermediate def-variable
RSString vV_STRING___3; // V_STRING_3: intermediate def-variable
RSString vV_DIM; // V_DIM_1: intermediate def-variable
RSBigInt vC_PARAMETER_TABLE__ISOPEN = RSBigInt("0"); // C_PARAMETER_TABLE::ISOPEN_1: intermediate def-variable
RSBigInt vC_PARAMETER_TABLE__FOUND = RSBigInt("0"); // C_PARAMETER_TABLE::FOUND_1: intermediate def-variable
RSBigInt vC_PARAMETER_TABLE__ROWCOUNT = RSBigInt("0"); // C_PARAMETER_TABLE::ROWCOUNT_1: intermediate def-variable
RSBigInt vC_PARAMETER_TABLE_DETAIL__ISOPEN = RSBigInt("0"); // C_PARAMETER_TABLE_DETAIL::ISOPEN_1: intermediate def-variable
RSBigInt vC_PARAMETER_TABLE_DETAIL__FOUND = RSBigInt("0"); // C_PARAMETER_TABLE_DETAIL::FOUND_1: intermediate def-variable
RSBigInt vC_PARAMETER_TABLE_DETAIL__ROWCOUNT = RSBigInt("0"); // C_PARAMETER_TABLE_DETAIL::ROWCOUNT_1: intermediate def-variable
RSInteger vCUR_ROW_ID; // CUR_ROW_ID_1: intermediate def-variable
RSString vCUR_ROW_TYPENAME; // CUR_ROW_TYPENAME_1: intermediate def-variable
RSString vCUR_ROW_DIRECTION; // CUR_ROW_DIRECTION_1: intermediate def-variable
RSNString vCUR_ROW_DETAIL_COLUMN_NAME; // CUR_ROW_DETAIL_COLUMN_NAME_1: intermediate def-variable
RSInteger vCUR_ROW_DETAIL_POSITION; // CUR_ROW_DETAIL_POSITION_1: intermediate def-variable
RSString vCUR_ROW_DETAIL_DATA_TYPE_NAME; // CUR_ROW_DETAIL_DATA_TYPE_NAME_1: intermediate def-variable
RSString vCUR_ROW_DETAIL_CS_DATA_TYPE_NAME; // CUR_ROW_DETAIL_CS_DATA_TYPE_NAME_1: intermediate def-variable
RSInteger vCUR_ROW_DETAIL_LENGTH; // CUR_ROW_DETAIL_LENGTH_1: intermediate def-variable
#pragma location " line 3 col 1 (at pos 162)"
vV_SCHEMA_NAME = expr::constructor_<RSString>("",0);
vV_SCHEMA_NAME.checkLengthLEAndThrow(1000z);
#pragma location " line 4 col 1 (at pos 197)"
vV_TABLE_NAME = expr::constructor_<RSString>("",0);
vV_TABLE_NAME.checkLengthLEAndThrow(1000z);
#pragma location " line 5 col 1 (at pos 231)"
vV_STRING = expr::constructor_<RSString>("",0);
vV_STRING.checkLengthLEAndThrow(32767z);
#pragma location " line 6 col 1 (at pos 262)"
vV_DIM = expr::constructor_<RSString>("",0);
vV_DIM.checkLengthLEAndThrow(100z);
#pragma location " line 7 col 1 (at pos 287)"
#pragma location " line 8 col 1 (at pos 369)"
// 588255__1
RSString vV_SCHEMA_NAME___3; // V_SCHEMA_NAME_3: intermediate defined variable
RSString vV_SCHEMA_NAME___5; // V_SCHEMA_NAME_5: intermediate defined variable
RSString vV_TABLE_NAME___3; // V_TABLE_NAME_3: intermediate defined variable
RSString vV_TABLE_NAME___4; // V_TABLE_NAME_4: intermediate defined variable
RSString vV_TABLE_NAME___6; // V_TABLE_NAME_6: intermediate defined variable
RSString vV_STRING___4; // V_STRING_4: intermediate defined variable
RSString vV_STRING___5; // V_STRING_5: intermediate defined variable
RSString vV_STRING___6; // V_STRING_6: intermediate defined variable
RSString vV_DIM___3; // V_DIM_3: intermediate defined variable
RSBigInt vC_PARAMETER_TABLE__ISOPEN___3 = RSBigInt("0"); // C_PARAMETER_TABLE::ISOPEN_3: intermediate defined variable
RSBigInt vC_PARAMETER_TABLE__FOUND___3 = RSBigInt("0"); // C_PARAMETER_TABLE::FOUND_3: intermediate defined variable
RSBigInt vC_PARAMETER_TABLE__ROWCOUNT___3 = RSBigInt("0"); // C_PARAMETER_TABLE::ROWCOUNT_3: intermediate defined variable
RSBigInt vC_PARAMETER_TABLE_DETAIL__ISOPEN___4 = RSBigInt("0"); // C_PARAMETER_TABLE_DETAIL::ISOPEN_4: intermediate defined variable
RSBigInt vC_PARAMETER_TABLE_DETAIL__FOUND___4 = RSBigInt("0"); // C_PARAMETER_TABLE_DETAIL::FOUND_4: intermediate defined variable
RSBigInt vC_PARAMETER_TABLE_DETAIL__ROWCOUNT___4 = RSBigInt("0"); // C_PARAMETER_TABLE_DETAIL::ROWCOUNT_4: intermediate defined variable
RSInteger vCUR_ROW_ID___3; // CUR_ROW_ID_3: intermediate defined variable
RSString vCUR_ROW_TYPENAME___3; // CUR_ROW_TYPENAME_3: intermediate defined variable
RSString vCUR_ROW_DIRECTION___3; // CUR_ROW_DIRECTION_3: intermediate defined variable
RSNString vCUR_ROW_DETAIL_COLUMN_NAME___4; // CUR_ROW_DETAIL_COLUMN_NAME_4: intermediate defined variable
RSInteger vCUR_ROW_DETAIL_POSITION___4; // CUR_ROW_DETAIL_POSITION_4: intermediate defined variable
RSString vCUR_ROW_DETAIL_DATA_TYPE_NAME___4; // CUR_ROW_DETAIL_DATA_TYPE_NAME_4: intermediate defined variable
RSString vCUR_ROW_DETAIL_CS_DATA_TYPE_NAME___4; // CUR_ROW_DETAIL_CS_DATA_TYPE_NAME_4: intermediate defined variable
RSInteger vCUR_ROW_DETAIL_LENGTH___4; // CUR_ROW_DETAIL_LENGTH_4: intermediate defined variable
#pragma location " line 14 col 1 (at pos 709)"
{
#pragma location " line 14 col 1 (at pos 709)"
TemporaryTableHandle ctabC_PARAMETER_TABLEDATA = TemporaryTableHandle(vDATA); // TempTableHandle for Cursor
PreparedStatement stmtC_PARAMETER_TABLE = conn.prepareStatement(String(" SELECT \"ID\", \"TYPENAME\", \"DIRECTION\" FROM ").append(tabDATA.getFullyQualifedName(), " ORDER BY \"ID\" ASC "), "static", "SYSTEM");
ResultSet rsC_PARAMETER_TABLE = stmtC_PARAMETER_TABLE.executeQuery();
vC_PARAMETER_TABLE__ISOPEN = expr::typecast_<RSBigInt>(1);
vC_PARAMETER_TABLE__ROWCOUNT = expr::typecast_<RSBigInt>(0);
while (rsC_PARAMETER_TABLE.next()) {
{
RSInteger tvCUR_ROW_ID = rsC_PARAMETER_TABLE.getRSInteger(1z);
vCUR_ROW_ID = tvCUR_ROW_ID;
}
{
RSString tvCUR_ROW_TYPENAME = rsC_PARAMETER_TABLE.getRSString(2z);
tvCUR_ROW_TYPENAME.checkLengthLEAndThrow(1000z);
vCUR_ROW_TYPENAME.copy(tvCUR_ROW_TYPENAME, env);
}
{
RSString tvCUR_ROW_DIRECTION = rsC_PARAMETER_TABLE.getRSString(3z);
tvCUR_ROW_DIRECTION.checkLengthLEAndThrow(100z);
vCUR_ROW_DIRECTION.copy(tvCUR_ROW_DIRECTION, env);
}
#pragma location " line 15 col 9 (at pos 753)"
{
RSString tV_SCHEMA_NAME = expr::substr_before_<RSString>(env,vCUR_ROW_TYPENAME,expr::constructor_<RSString>(".",1));
tV_SCHEMA_NAME.checkLengthLEAndThrow(1000z);
vV_SCHEMA_NAME = tV_SCHEMA_NAME;
}
// 588255__2
#pragma location " line 16 col 12 (at pos 819)"
if (expr::ne_<RSBoolean>(vV_SCHEMA_NAME,expr::constructor_<RSString>("",0)).isTrue()) {
// 588255__3
#pragma location " line 17 col 17 (at pos 861)"
{
RSString tV_TABLE_NAME = expr::substr_after_<RSString>(env,vCUR_ROW_TYPENAME,expr::constructor_<RSString>(".",1));
tV_TABLE_NAME.checkLengthLEAndThrow(1000z);
vV_TABLE_NAME = tV_TABLE_NAME;
}
}
else {
// 588255__4
#pragma location " line 19 col 17 (at pos 943)"
{
RSString tV_TABLE_NAME = vCUR_ROW_TYPENAME;
tV_TABLE_NAME.checkLengthLEAndThrow(1000z);
vV_TABLE_NAME = tV_TABLE_NAME;
}
}
#pragma location " line 21 col 9 (at pos 1001)"
{
RSString tV_STRING___4 = expr::concat_<RSString>(env,vV_STRING,expr::constructor_<RSString>(";",1));
tV_STRING___4.checkLengthLEAndThrow(32767z);
vV_STRING___4 = tV_STRING___4;
}
#pragma location " line 22 col 9 (at pos 1039)"
{
RSString tV_STRING = expr::concat_<RSString>(env,expr::concat_<RSString>(env,expr::concat_<RSString>(env,expr::concat_<RSString>(env,expr::concat_<RSString>(env,expr::concat_<RSString>(env,vV_STRING___4,vV_TABLE_NAME),expr::constructor_<RSString>(",",1)),vCUR_ROW_DIRECTION),expr::constructor_<RSString>(",",1)),expr::constructor_<RSString>("TrexTable",9)),expr::constructor_<RSString>(",,,,",4));
tV_STRING.checkLengthLEAndThrow(32767z);
vV_STRING = tV_STRING;
}
// 588255__5
RSString vV_STRING___7; // V_STRING_7: intermediate defined variable
RSString vV_STRING___9; // V_STRING_9: intermediate defined variable
RSString vV_DIM___4; // V_DIM_4: intermediate defined variable
RSString vV_DIM___5; // V_DIM_5: intermediate defined variable
#pragma location " line 23 col 9 (at pos 1144)"
{
#pragma location " line 23 col 9 (at pos 1144)"
PreparedStatement stmtC_PARAMETER_TABLE_DETAIL = conn.prepareStatement(String(" SELECT \"COLUMN_NAME\", \"POSITION\", \"DATA_TYPE_NAME\", \"CS_DATA_TYPE_NAME\", \"LENGTH\" FROM \"PUBLIC\".\"TABLE_COLUMNS\" WHERE ( \"SCHEMA_NAME\" = CASE WHEN ? <> '' THEN ? ELSE \"SCHEMA_NAME\" END AND \"TABLE_NAME\" = ? ) ORDER BY \"POSITION\" ASC "), "static", "SYSTEM");
stmtC_PARAMETER_TABLE_DETAIL.setRSString(1z, vV_SCHEMA_NAME);
stmtC_PARAMETER_TABLE_DETAIL.setRSString(2z, vV_SCHEMA_NAME);
stmtC_PARAMETER_TABLE_DETAIL.setRSString(3z, vV_TABLE_NAME);
ResultSet rsC_PARAMETER_TABLE_DETAIL = stmtC_PARAMETER_TABLE_DETAIL.executeQuery();
vC_PARAMETER_TABLE_DETAIL__ISOPEN = expr::typecast_<RSBigInt>(1);
vC_PARAMETER_TABLE_DETAIL__ROWCOUNT = expr::typecast_<RSBigInt>(0);
while (rsC_PARAMETER_TABLE_DETAIL.next()) {
{
RSNString tvCUR_ROW_DETAIL_COLUMN_NAME = rsC_PARAMETER_TABLE_DETAIL.getRSNString(1z);
tvCUR_ROW_DETAIL_COLUMN_NAME.checkLengthLEAndThrow(256z);
vCUR_ROW_DETAIL_COLUMN_NAME.copy(tvCUR_ROW_DETAIL_COLUMN_NAME, env);
}
{
RSInteger tvCUR_ROW_DETAIL_POSITION = rsC_PARAMETER_TABLE_DETAIL.getRSInteger(2z);
vCUR_ROW_DETAIL_POSITION = tvCUR_ROW_DETAIL_POSITION;
}
{
RSString tvCUR_ROW_DETAIL_DATA_TYPE_NAME = rsC_PARAMETER_TABLE_DETAIL.getRSString(3z);
tvCUR_ROW_DETAIL_DATA_TYPE_NAME.checkLengthLEAndThrow(16z);
vCUR_ROW_DETAIL_DATA_TYPE_NAME.copy(tvCUR_ROW_DETAIL_DATA_TYPE_NAME, env);
}
{
RSString tvCUR_ROW_DETAIL_CS_DATA_TYPE_NAME = rsC_PARAMETER_TABLE_DETAIL.getRSString(4z);
tvCUR_ROW_DETAIL_CS_DATA_TYPE_NAME.checkLengthLEAndThrow(16z);
vCUR_ROW_DETAIL_CS_DATA_TYPE_NAME.copy(tvCUR_ROW_DETAIL_CS_DATA_TYPE_NAME, env);
}
{
RSInteger tvCUR_ROW_DETAIL_LENGTH = rsC_PARAMETER_TABLE_DETAIL.getRSInteger(5z);
vCUR_ROW_DETAIL_LENGTH = tvCUR_ROW_DETAIL_LENGTH;
}
#pragma location " line 24 col 17 (at pos 1210)"
{
RSString tV_STRING___7 = expr::concat_<RSString>(env,vV_STRING,expr::constructor_<RSString>(";",1));
tV_STRING___7.checkLengthLEAndThrow(32767z);
vV_STRING___7 = tV_STRING___7;
}
// 588255__6
#pragma location " line 25 col 20 (at pos 1259)"
if (expr::or_<RSBoolean>(expr::eq_<RSBoolean>(vCUR_ROW_DETAIL_DATA_TYPE_NAME,expr::constructor_<RSString>("VARCHAR",7)),expr::eq_<RSBoolean>(vCUR_ROW_DETAIL_DATA_TYPE_NAME,expr::constructor_<RSString>("NVARCHAR",8))).isTrue()) {
// 588255__7
#pragma location " line 26 col 25 (at pos 1376)"
{
RSString tV_DIM = expr::typecast_<RSString>(env,vCUR_ROW_DETAIL_LENGTH);
tV_DIM.checkLengthLEAndThrow(100z);
vV_DIM = tV_DIM;
}
}
else {
// 588255__8
#pragma location " line 28 col 25 (at pos 1453)"
{
RSString tV_DIM = expr::constructor_<RSString>("",0);
tV_DIM.checkLengthLEAndThrow(100z);
vV_DIM = tV_DIM;
}
}
#pragma location " line 30 col 17 (at pos 1506)"
{
RSString tV_STRING = expr::typecast_<RSString>(env,expr::concat_<RSNString>(env,expr::concat_<RSNString>(env,expr::concat_<RSNString>(env,expr::concat_<RSNString>(env,expr::concat_<RSNString>(env,expr::concat_<RSNString>(env,expr::concat_<RSNString>(env,expr::typecast_<RSNString>(vV_STRING___7),vCUR_ROW_DETAIL_COLUMN_NAME),expr::typecast_<RSNString>(expr::constructor_<RSString>(",,,",3))),expr::typecast_<RSNString>(vCUR_ROW_DETAIL_CS_DATA_TYPE_NAME)),expr::typecast_<RSNString>(expr::constructor_<RSString>(",,",2))),expr::typecast_<RSNString>(vCUR_ROW_DETAIL_DATA_TYPE_NAME)),expr::typecast_<RSNString>(expr::constructor_<RSString>(",",1))),expr::typecast_<RSNString>(vV_DIM)));
tV_STRING.checkLengthLEAndThrow(32767z);
vV_STRING = tV_STRING;
}
}
}
}
}
#pragma location " line 33 col 1 (at pos 1681)"
{
RSString tV_STRING___3 = expr::concat_<RSString>(env,vV_STRING,expr::constructor_<RSString>(";",1));
tV_STRING___3.checkLengthLEAndThrow(32767z);
vV_STRING___3 = tV_STRING___3;
}
#pragma location " line 34 col 1 (at pos 1711)"
{
CallableStatement stmt0 = conn.prepareCall(String("{ call \"SYSTEM\".\"AFLPM_CREATEPROCEDURE\" (?, ?, ?, ?) }"), "static", "SYSTEM");
stmt0.setRSString(1z, vAREA);
stmt0.setRSString(2z, vAFL);
stmt0.setRSString(3z, vPROC);
stmt0.setRSString(4z, vV_STRING___3);
stmt0.execute();
}
}
""")
[51436]{242986}[-2378730] 2013-02-19 00:41:42.256366 e cePlanExec cePlanExecutor.cpp(06157) : Error during Plan execution of model SYSTEM:_SYS_SS_CE_588255_INS (-1), reason: SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1711): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace
I'd open a support oss message.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.