Data Base Connect DUMP.

[Former Member]

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

[Former Member]

What information is given in the dump?

Rob

[Former Member]

Thank you for your response!

[raphael_almeida]

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

[raphael_almeida]

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

[Former Member]

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