IBM Support

Unable to Create New Data Sheet

Troubleshooting


Problem

Receive error while creating a new record in Datasheet (Cal) after enabling the auto-key prefix with 'AP' and 'NA'.

Symptom

Steps:

1. Go to the Organizations application, select action menu > Autonumber Setup > System Level.

2. Filter for auto numbers that start with Plus.

Enter AP as the prefix for PLUSCDSINSTRINSTRSEQ and PLUSCWODSWODSNUM





3. Select action menu > Autonumber Setup > Organization Level.
Enter AP as the prefix for PLUSCWODSWODSNUM



4. Select action menu > Autonumber Setup > Site Level.
Enter AP as the prefix for PLUSCWODSWODSNUM




5. Go to Planning > Data Sheet Template, click "New", and then click "New Row" under Asset Functions within the Data Sheet tab. The result is that the following error is displayed:

BMXAA420E - Database error number 245 has occurred
[KLM1SQL01V501\MAXIMO]Conversion failed when converting the varchar
value 'AP0000001234' to data type int.

Cause

Excerpt from the SQL log:

select seed, prefix from autokey
where autokeyname = 'PLUSCDSINSTRINSTRSEQ'
and orgid is null and siteid is null

Run the query below:

SELECT OBJECTNAME,ATTRIBUTENAME,MAXTYPE FROM MAXATTRIBUTE
WHERE 'PLUSCDSINSTRINSTRSEQ'

output: PLUSCDSINSTR.INSTRSEQ

Run the query below:
SELECT OBJECTNAME,ATTRIBUTENAME,MAXTYPE FROM MAXATTRIBUTE
WHERE ATTRIBUTENAME='INSTRSEQ '

Since we have a autokey prefix of 'NA', INTEGER data type for INSTRSEQ will not support STRING.

Resolving The Problem

Currently the Data Sheet Templates and Data Sheets referenced in work orders only support integer data type and do not support VARCHAR data type. Either we don't setup any prefixes or we must use INTEGER as the prefix in the Organization application, Autonumber setup for data sheets to work properly.


Steps:
1. Go to the Organizations application, bring up the appropriate organization, go to the Select Actions menu, Autonumber setup, Organization level, change the prefix for PLUSCWODSWODSNUM to an integer.

2. Go to the Organizations application, bring up the appropriate organization, go to the Select Actions menu, Autonumber setup, systemlevel, change the prefix for PLUSCDSINSTRINSTRSEQ and PLUSCWODSWODSNUM to an integer.

3. Go to the Planning module, Data Sheet Template application, click "New", and then click "New Row" under Asset Functions within the Data Sheet tab, enter a new asset function. The error will no longer be displayed.

[{"Product":{"code":"SSLKZS","label":"Maximo Calibration"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Calibration","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.4;6.5;7.1;7.1.2;7.2.1;7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21507200