Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Conditional Map script error

798182Feb 9 2011 — edited Apr 11 2011
Hi Guys,

Does anyone know what I have done wrong in the following conditional map script. What strikes me by the way is that suddenly this is blocking me from importing, while for other locations this is not the case.

Many thanks for your help!
JDeM


** Begin FDM Runtime Error Log Entry [2011-02-09-18:39:51] **
-------------------------------------------------------------
ERROR:
Code............................................. 0
Description...................................... Conditional Map Script Error: at line(-1)

Script:
IF varValues(14)= "NET_INCOME" Then
Result="[ICP None]"

Else IF (left(varValues(13),1)= "I" OR left(varValues(13),1)= "T") Then
Result="[ICP None]"

Else Result= varValues(17)
End IF
End IF
Rule=ALL

Procedure........................................ clsCalcEngine.fFlagWildcard
Component........................................ upsWObjectsDM
Version.......................................... 1111
Thread........................................... 7116

IDENTIFICATION:
User............................................. ADMIN
Computer Name.................................... DCEPHFMTSTDB1
App Name......................................... FDMTEST
Client App....................................... WebClient

CONNECTION:
Provider......................................... ORAOLEDB.ORACLE
Data Server......................................
Database Name.................................... HYPDB
Trusted Connect.................................. False
Connect Status.. Connection Open

GLOBALS:
Location......................................... AEP866
Location ID...................................... 783
Location Seg..................................... 29
Category......................................... WLACT2010
Category ID...................................... 12
Period........................................... Nov - 2010
Period ID........................................ 11/30/2010
POV Local........................................ False
Language......................................... 1033
User Level....................................... 1
All Partitions................................... True
Is Auditor....................................... False


** Begin FDM Runtime Error Log Entry [2011-02-09-18:39:51] **
-------------------------------------------------------------
ERROR:
Code............................................. 5
Description...................................... Invalid procedure call or argument
Procedure........................................ clsCalculationMgr.fProcessMap
Component........................................ upsWObjectsDM
Version.......................................... 1111
Thread........................................... 7116

IDENTIFICATION:
User............................................. ADMIN
Computer Name.................................... DCEPHFMTSTDB1
App Name......................................... FDMTEST
Client App....................................... WebClient

CONNECTION:
Provider......................................... ORAOLEDB.ORACLE
Data Server......................................
Database Name.................................... HYPDB
Trusted Connect.................................. False
Connect Status.. Connection Open

GLOBALS:
Location......................................... AEP866
Location ID...................................... 783
Location Seg..................................... 29
Category......................................... WLACT2010
Category ID...................................... 12
Period........................................... Nov - 2010
Period ID........................................ 11/30/2010
POV Local........................................ False
Language......................................... 1033
User Level....................................... 1
All Partitions................................... True
Is Auditor....................................... False


** Begin FDM Runtime Error Log Entry [2011-02-09-18:39:51] **
-------------------------------------------------------------
ERROR:
Code............................................. 5
Description...................................... Invalid procedure call or argument
Procedure........................................ clsImpProcessMgr.fLoadAndProcessFile
Component........................................ upsWObjectsDM
Version.......................................... 1111
Thread........................................... 7116

IDENTIFICATION:
User............................................. ADMIN
Computer Name.................................... DCEPHFMTSTDB1
App Name......................................... FDMTEST
Client App....................................... WebClient

CONNECTION:
Provider......................................... ORAOLEDB.ORACLE
Data Server......................................
Database Name.................................... HYPDB
Trusted Connect.................................. False
Connect Status.. Connection Open

GLOBALS:
Location......................................... AEP866
Location ID...................................... 783
Location Seg..................................... 29
Category......................................... WLACT2010
Category ID...................................... 12
Period........................................... Nov - 2010
Period ID........................................ 11/30/2010
POV Local........................................ False
Language......................................... 1033
User Level....................................... 1
All Partitions................................... True
Is Auditor....................................... False
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2011
Added on Feb 9 2011
7 comments
406 views