USER Custom Column not working

[Brian_Boegs]

We used all the 10-150 cust cols for the users, so I added a new user custom field to the system using the "Add New" link. It shows up on the users screen but does not work in

• reports - cannot query the new field in the cust column view
• connector file mapping
• assignment profile - not in the select attribute drop down.

In my report, it does not show up in the PV_STUD_CUST_COLUMN view

SAP DBTech JDBC: [260]: invalid column name: CC_STUD_160

When I map the connector file to the new field, I get the following error:

com.plateausystems.connector.api.ConnectorException: Column doesn't exists :COL_NUM16_VAL in tables [pa_conn_stud_user, pa_conn_student]

Is there a process I need to run to get this new field added to the system??

[ChrisStiles · Accepted solution]

Try running the APM "Assignment Profiles Execute Updates" ... new custom columns are not available to assignment profiles until this job is run .. so maybe this is also true for reports?

[Brian_Boegs]

That did the trick. It was disable on our staging platform.