Recently, one of our customer encountered SQL syntax error when accessing fixed asset module. 

To access Fixed Asset module, Sage X3 will generate SQL script to get the value of of total count of fixed asset records across the folders. But the script generated by the system hit SQL error due to negative value has been concatenated to populate View name. I can see the error by retrieving the sql script and manually run the SQL database. 

Here is the error prompte:

To further investigation, I found out the negative value is come from adxuid(2). And this system variable is assigned during login of Sage X3. From what my observation in another environment where is working correctly, there's no negative value and the value is comes from X3.ASYSSMPROCES.SESSIONID which is generated from next sequence number of SEQ_ASYSSMPROCES.

The system fail to get the correct sequence number and at the end only I found out no permission has been granted for X3_ADX_SYS role in SQL for SEQ_ASYSSMPROCES, SEQ_ASYSSMINTERN, SEQ_ASYSSMDBASSO sequences. Once update permission granted, the issue is solved.