Skip to main content
Delphix

Data Level profiling job fails with error "TypeError: Cannot find function getInteger in object false." (KBA8258)

 

KBA

KBA# 8258

 

Issue

A profile Job fails with the following Errors.

2021/10/22 11:18:53 - bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94 - Loading transformation from XML file [/var/delphix/masking/output/Name/DMSApplicator/profiler_rs/1/KETTLE_PROFILING_XML_1_bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94_25.xml]
2021/10/22 11:18:53 - bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94 - Using legacy execution engine
2021/10/22 11:18:53 - KETTLE_PROFILING_XML_1_bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94_25 - Dispatching started for transformation [KETTLE_PROFILING_XML_1_bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94_25]
2021/10/22 11:18:53 - Table input.0 - Initializing ThroughputLogger
2021/10/22 11:18:53 - Modified Java Script Value.0 - Optimization level set to -1.
2021/10/22 11:18:53 - Modified Java Script Value.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Unexpected error
2021/10/22 11:18:53 - Table input.0 - ThroughputLogger:interval 0.001 MB (100 rows) counted in 0.028 sec; throughput = 0.032 MB/sec
2021/10/22 11:18:53 - Table input.0 - ThroughputLogger:total 0.001 MB (100 rows) counted in 0.028 sec; throughput = 0.032 MB/sec
2021/10/22 11:18:53 - Table input.0 - Finished reading query, closing connection.
2021/10/22 11:18:53 - Modified Java Script Value.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : org.pentaho.di.core.exception.KettleValueException:
2021/10/22 11:18:53 - Modified Java Script Value.0 - Javascript error:
2021/10/22 11:18:53 - Modified Java Script Value.0 - TypeError: Cannot find function getInteger in object false. (script#11)
2021/10/22 11:18:53 - Modified Java Script Value.0 -
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:475)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.processRow(ScriptValuesMod.java:541)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at java.lang.Thread.run(Thread.java:748)
2021/10/22 11:18:53 - Modified Java Script Value.0 - Caused by: org.mozilla.javascript.EcmaError: TypeError: Cannot find function getInteger in object false. (script#11)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3785)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3763)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3791)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3810)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:3881)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThisHelper(ScriptRuntime.java:2360)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis(ScriptRuntime.java:2327)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1514)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:854)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:164)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:426)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3178)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.mozilla.javascript.InterpretedFunction.exec(InterpretedFunction.java:175)
2021/10/22 11:18:53 - Modified Java Script Value.0 - at org.pentaho.di.trans.steps.scriptvalues_mod.ScriptValuesMod.addValues(ScriptValuesMod.java:388)
2021/10/22 11:18:53 - Modified Java Script Value.0 - ... 3 more
2021/10/22 11:18:53 - Select Values.0 - Finished processing (I=0, O=0, R=100, W=100, U=0, E=0)
2021/10/22 11:18:53 - Table input.0 - Finished processing (I=100, O=0, R=0, W=100, U=0, E=0)
2021/10/22 11:18:54 - Modified Java Script Value.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2021/10/22 11:18:54 - KETTLE_PROFILING_XML_1_bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94_25 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Errors detected!
2021/10/22 11:18:54 - KETTLE_PROFILING_XML_1_bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94_25 - Transformation detected one or more steps with errors.
2021/10/22 11:18:54 - KETTLE_PROFILING_XML_1_bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94_25 - Transformation is killing the other steps!
2021/10/22 11:18:54 - KETTLE_PROFILING_XML_1_bit_profiler_test-f8736fd4-ccd8-38aa-989d-0f7fb4356d94_25 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : Errors detected!

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies
Major Release All Sub Releases
6.0 6.0.0.0, 6.0.1.0, 6.0.1.1, 6.0.2.0, 6.0.2.1, 6.0.3.0, 6.0.3.1, 6.0.4.0, 6.0.4.1, 6.0.4.2, 6.0.5.0, 6.0.6.0, 6.0.6.1, 6.0.7.0, 6.0.8.0, 6.0.8.1, 6.0.9.0, 6.0.10.0, 6.0.10.1

5.3

5.3.0.0, 5.3.0.1, 5.3.0.2, 5.3.0.3, 5.3.1.0, 5.3.1.1, 5.3.1.2, 5.3.2.0, 5.3.3.0, 5.3.3.1, 5.3.4.0, 5.3.5.0, 5.3.6.0, 5.3.7.0, 5.3.7.1, 5.3.8.0, 5.3.8.1, 5.3.9.0

5.2

5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1, 5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4

Resolution

To resolve this issue check that the IgnoreDatatype settings in the API profile group contain the default datatypes that a profiling Job should ignore. 
 
The Application Setting API allows an administrator to change the Delphix Masking Engine settings, including profile group settings. 
For more information refer to https://maskingdocs.delphix.com/Delphix_Masking_APIs/Masking_Client/Masking_API_Client/#profile-group-settings

To check these values take the following action from the API (http://EngineURL/masking/api-client).

Snip20211022_15.png

 

 

After Logging into and Connecting to the Masking API Client (KBA5754) select applicationSettings and GET applicationSettings to determine the settingId for IgnoreDatatype. 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Snip20211022_19.png

 

 

After confirming the settingID select application-settings(settingId) enter in the value field and Execute API Request to retrieve the list of datatypes the profiler Job will ignore. The default list is shown here. 

 

 

 

 

 

 

 

 

 

 

 

 

If this list has been edited to remove values, for example BIT, and the Profiler Job encounters a column of the datatype BIT, it will default to datatype Integer. This will cause problems and the Job will fail with the above error.

Typically this list would only be appended to, allowing further datatypes that may not be considered sensitive to be ignored by the profiling Job. 

Check the datatypes for the table columns being profiled and make sure that there are no datatypes which, by default, would be ignored by Profiler but under the API profile IgnoreDatatype values are not listed.  

If this list is as expected, please contact Delphix for further support. If it is the case that there are missing default datatypes then follow the instructions below to revert the changes, and include the missing default datatype(s).

Snip20211022_22.png

 

 

Within the body include the missing datatype. 

 

 

 

 

 

 

 

 

 

 

 

For 6.0.10 the list in text format is:

BIT,BOOLEAN,CHAR#1,VARCHAR#1,VARCHAR2#1,NCHAR#1,NVARCHAR#1,NVARCHAR2#1,BINARY,VARBINARY,IMAGE,LOB,LONG,BLOB,CLOB,NCLOB,BFILE,RAW,ENUM,BFILE

Re-run the profiler Job. 

Troubleshooting