0 votes

Hello everyone,

I have an error when i execute a simple query on the views like :

select * from R_COMPANIES

i got this msg :

Msg 537, Level 16, State 3, Line 1
Invalid length parameter passed to the LEFT or SUBSTRING function.

NB: it just for the companies view "R_COMPANIES"

Thank you

Regards

asked in Database by (102 points)

2 Answers

0 votes

I suppose you have modified the standard view, because I don't reproduce any error in either standard in SQL server nor Oracle.

answered by (249 points)
0 votes

The R_VIEWS are regenerated with the DbUpgrade process becaus
e they are based on the dictionary configuration from SYS_FIELDS. For every lookup and multivalue, the R_ column is appended containing the text label instead of the key.

Proceed by running a DbUpgrade to force recreation of all R_VIEWS

answered by (6.8k points)
1,166 questions
1,424 answers
1,716 comments
325 users