topic Data Base Connect DUMP. in Application Development and Automation Discussions

Data Base Connect DUMP.

Former Member — Fri, 23 Jan 2015 15:38:02 GMT

Hi all,

We’re having a problem when try to connect a specific data base.

A short dump occurs sometimes (no always) when the follow instructions are raised:

EXEC SQL.

CONNECT TO :iv_conector as :l_alias

ENDEXEC.

We talk with DBA team and, according to them, there is no problem with the connection.

When we run this program’s logic using the debug mode, the program runs normally without short dump.

Anybody has an idea how to solve this problem?

Thanks.

Jorge Bastos

Re: Data Base Connect DUMP.

Former Member — Fri, 23 Jan 2015 16:33:49 GMT

What information is given in the dump?

Rob

Re: Data Base Connect DUMP.

Former Member — Fri, 23 Jan 2015 17:38:02 GMT

Thank you for your response!

Re: Data Base Connect DUMP.

raphael_almeida — Fri, 23 Jan 2015 19:33:41 GMT

Hi Jorge,

First, this program was connected before?

Second, why are you using Alias to call the connection?

Can you explain for us?!

BR,

Raphael

Re: Data Base Connect DUMP.

raphael_almeida — Fri, 23 Jan 2015 19:52:27 GMT

Adding, I did not understand the purpose of this Alias, it will always be different every second, or day or when the program is called by another user.

Try this way:

DATE: o_connect type ref to cl_sql_connection,
v_dbcon type dbcon-con_name, "Receive the DBCO connection name (CON_NAME)

create object go_connect.
go_connect cl_sql_connection = => get_connection (gv_dbcon).

... (Statements)

For more examples of how to connect or use open_sql, see the program ADBC_DEMO.

Hope this helps !

BR,

Raphael

Re: Data Base Connect DUMP.

Former Member — Fri, 23 Jan 2015 23:09:37 GMT

Hi Jorge,

I suspect some data type problem with l_alias.What is the data type of this variable.

You are adding some Z and date stamp for some reference and i can see u used condense statement with No Gaps.

Note default value of a char is " ".Which will eliminate 0 values ..which will result in some mismatch with your DBCON entries..

Please share the Dump variable value screenshot of the above dump.

Regards,

Kannan