Hi there,
I’m using the DB writer to writer a table into Microsoft SQL Server and have received the following error message, please see the file attachment:
Is there a way to address this issue.
Thank you.
Ian
Hi @RNIB_ianhill, does the table already exist in sql server or is it being created by the db writer?
If it already exists, what is the table definition on sql server?
The error message suggests you have a column name :
Is that really the column name you intended?
2 Likes
Hi there,
The table is being created by the db writer. The column name is CSDM_Responder_Flag1. The value we are modelling is Responder.
I believe the name shown is a combination of the variable name and value that is being modelled. Is there any to control this?
Thank you.
Regards.
Ian
Regards.
Ian
In your error message, it looks like the column names contains a leading capital P, along with a space and some parentheses. This is very likely the probability of prediction for your target variable coming out of the predictor node. I suspect somewhere in there is a character your DB doesn’t allow.
You need to change the name of the variable coming out of the predictor node - try a String Manipulation node and see if your DB likes that better.
1 Like