1. Home
  2. Support
Article - CS275062

Error "LRM-00112: multiple values not allowed for parameter 'userid'" during Get Host Data process in Servigistics Parts Planning (SPM)

Modified: 15-Oct-2019   


Applies To

  • Servigistics Service Parts Management 11.3.1 N/A to 11.3.2 N/A
  • Oracle Database Server 12c

Description

  •  BulkInsert/sqlldr processes such as Get Host Data fail 
    • LRM-00112: multiple values not allowed for parameter 'userid'
  • 2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.dataprovider.bulkinsert.OracleBulkInsert - sqlldr direct=true userid=SPM/abc,123,4T control=/xxx/Servigistics/Servigistics/BulkInsert/BULK_CTLxxx-x.ctl log=/xxx/Servigistics/Servigistics/BulkInsert/BULK_CTLxxx-x.log ​
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd - ** OUTPUT **
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd - ** ERRORS **
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd - LRM-00112: multiple values not allowed for parameter 'userid'
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd -
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd - SQL*Loader: Release 12.1.0.2.0 - Production on Sat Nov 11 16:26:50 2017
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd -
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd - Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd -
2017-11-11 16:26:50,117[SubTask-152] DEBUG com.svg.core.util.ExecCmd - SQL*Loader-100: Syntax error on command-line
... 2017-11-11 16:26:50,133[SubTask-152] ERROR com.svg.core.util.EventLog - Task Get Host Data failed with message: SQL Loader failed.
  • Special character , in Oracle database password
    • ​abc,123,4T
This is a printer-friendly version of Article 275062 and may be out of date. For the latest version click CS275062