Hi Guys
I am facing one problem in one of the session
I.e. I am getting BW message error can’t continue
Now in this session a function tcmcs0095.read.parm("tdind000") is called and this function is some thing like this

function tcmcs0095.read.parm(domain tcmcs.str8 file)
{
long sql
domain tcmcs.st30 table.desc

sql = sql.parse("select " & file & ".* " &
"from " & file & " " &
"as set with 1 rows")
sql.exec(sql)
if sql.fetch(sql) = enorec then
abort.transaction()
tt.table.desc(file, table.desc)
| mess("tcmcss0104", 1, table.desc) |#10018804.o
process.mess(1,1,"","tcmcss0104",table.desc) |#10018804.n
#pragma used message tcmcss0104 |#10018804.n
| %s not found
job.process.error = true
sql.close(sql)
end()
endif
sql.close(sql)
tcmcs0095.read.additional.information(file) |#np01.n

}

But sadly while debugging I found out that variable sql is a very large number and sql.fetch(sql) holds true as enorec due to which BW error message occurs, this what I could evaluate
What should I do? Help me; these errors are some times misleading errors

Thanks
bye

I have some suggestion/questions about this.

1) there are some records in tdinv000 (I think this is a parameter table of the indian localization, isn't it? - It has to contain exactly one record.... you can check with ttaad4500.). If the sql_fetch is set to enorec, it means there are no records selected.

2) sql variable is a pointer to a sql query, so is correct it contains a very large number (it is a long, not a string).

3) The message "Can not continue" probably is because a transaction is not correctly ended by a commit.transaction() or an abort.transaction()... this is due to the instruction end() in the function.

Arun,

Can you please post the BW error message ?

Are you sure that the table exists in the company you are working in ?