TM1 Forum

Hello,
I have a TI process that uses ODBCOutput with a 'Delete' and 'Insert' sql statements.
It worked in one T1 process but gave a System Stack Overflow message when I tried to export other data into another table in the sql server. I am using v9.0SP3. Does anyone know what will trigger this system stack overflow message?

Hi

I think you might be having the same issue we already reported to IBM as a bug.
What we found is that in that version the EXPAND function commonly used in the ODBCOutPut to prevent the stack overflow when creating a query which is more than 256 Charachters long is not doing what it is supposed to do.

In short: your query text in the ODBCOtuPut might be longer than 256 Characters.

Cheers

I tested it with a shorter sql just to test if there was something else.
So I am just exporting a project name and for a particular project, the name is Acme's 15th Anniversary.
The ' is causing the TI process to fail. My sql is below. How do I tackle the ' in the project name?


s_SQL = 'INSERT INTO ProjectInfo_Version2 ([ProjCode], [Name]) '
| 'Values ('
| Char( 39) | Projectcode | Char( 39) | ', '
| Char( 39) | ProjectName | Char( 39) | ')';