Maximo Open Forum

Hi Kane, 

Your syntax should be written like this if i am not wrong. The First From is not needed I believe.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3,
FROM table1
WHERE condition;

Ticket table has many views. Check the changes are correctly cascaded to other Views like SR and Incident.

Hello Subhransu, Thanks so much for your reply. Greatly appreciated. The changes are not correctly cascaded to other tables. one of the fields length to change is on the work order table. I am trying to increase the length of the workorder wonum field  to 15. Saving the changes gives the error on the screenshot below. I could change other attributes, but not in workorder table.

Hi Kane, 

Your syntax should be written like this if i am not wrong. The First From is not needed I believe.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3,
FROM table1
WHERE condition;

Ticket table has many views. Check the changes are correctly cascaded to other Views like SR and Incident.

HI Kane, 

Sorry for the late reply. In our case, it was coming while creating inventory PICK List on Manage Inventory Work center (Maximo 7613), we have raised a case to IBM and IBM is still working on it as the issue was not fixed by IFIX 004 provided by them. For us, the date time format issue was coming when I used to select a required date beyond 12th of a month as maximo was swapping the Date and Month values beyond 12. E.g. 5th APRIL 2023 was saved as 4th May 2023 in DB.

Which Version of Maximo you are using? Which country are you in? What type of date format used in your country? 

Hello Subhransu, Thanks so much for your reply. Greatly appreciated. The changes are not correctly cascaded to other tables. one of the fields length to change is on the work order table. I am trying to increase the length of the workorder wonum field  to 15. Saving the changes gives the error on the screenshot below. I could change other attributes, but not in workorder table.

Hi Kane, 

Your syntax should be written like this if i am not wrong. The First From is not needed I believe.

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3,
FROM table1
WHERE condition;

Ticket table has many views. Check the changes are correctly cascaded to other Views like SR and Incident.