Conditional Map script error
798182Feb 9 2011 — edited Apr 11 2011Hi 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