PAL - [423]: liveCache error SYSTEM.AFL_WRAPPER_GENERATOR

[Former Member]

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

[Former Member · Accepted solution]

Alexander,

Test this construction :

call SYSTEM.afl_wrapper_generator ('PAL_ANOMALY_DETECTION1', 'AFLPAL', 'ANOMALYDETECTION', PDATA)

and check PDATA(only distinct values in it)

[venkataramana_paidi · Accepted solution]

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.

[former_member184871 · Accepted solution]

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

[Former Member]

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

[former_member184871]

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

[subramanianselvan]

Hi all,

Is the below step executed ?

Go to

/hanamnt/<SID>/HDB <instance_number>/exe/plugins/afl/ and execute the afl_wrapper_generator.sql script file.

Regards

Subbu

[former_member184871]

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.

[Former Member]

I had this error 'liveCashe [423]' when in schema was procedure with same name. Or this error may be when some parameters are wrong.

[lbreddemann]

Hi Alexander,

what does the indexserver trace file has to say about this?

- Lars

[Former Member]

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

1. pop.setLocation('hana-2', 30503)
2. pop.setNodeName('$$DUMMY$$_SYS_SS_CE_588255_TMP_CALL')
3. pop.setUseInternalTable()

pi = fuzzypy.CePlanInput()

1. pi.setName('DATA')
2. pop.addPopInput(pi)
3. pop.addViewAttribute('DUMMY', datatype=67, intDigits=1, sqlType=8, sqlLength=1)
4. pop.setUserSchema('BI_PROJECT_TMP')
5. pop.addOutputName('dummy')
6. pop.addConnectorOutputPos(0)
7. pop.addPlanDebugOpDataInfo(originalNodeName = '$$DUMMY$$', scenarioName = 'SYSTEM:_SYS_SS_CE_588255_TMP')
8. pop.setScript("""

#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();

    }

}

""")

1. pop.setNameOfMainFunction('main')
2. pop.addParameter('PROC','PAL_LINEAR_TEST',0,83, 5000, 0)
3. pop.addParameter('AREA','AFLPAL',0,83, 5000, 0)
4. pop.addParameter('AFL','LRREGRESSION',0,83, 5000, 0)
5. pop.addInputNodeMapping('DATA','DATA')
6. pop.setNameOfContext('sp')
7. pop.setSchema('SYSTEM')
8. pop.setExecuteUser('SYSTEM')
9. pop.setScenarioName('SYSTEM:_SYS_SS_CE_588255_INS')
10. pop.setCacheKey('"SYSTEM"."_SYS_SS_CE_588255_TMP".51199925050BA63EE1000000C0A82A1D')

[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

[Former Member]

...the relevant passage seems to be here:

tV_STRING___3.checkLengthLEAndThrow(32767z);

vV_STRING___3 = tV_STRING___3;

    }

    #pragma location " line 34 col 1 (at pos 1711)"

    {

Is there something wrong regarding parameterization?

Cheers
Alex

[henrique_pinto]

I'd open a support oss message.