Question

There is an application on where i add some people's details and click Save, but it throws error. How to find workaround?

  • 14 January 2022
  • 8 replies
  • 5 views

Userlevel 2
Badge +8

It was giving this error on A360, and was perfectly running on A11, but it started to give error on A11 too.

 

When the bot fills the places(textboxes) and click on Save, it throws error.

 

When the bot fills the places, and I click on Save, it throws same error

 

When I fill the places manually, and click on Save, it works perfectly.. What may be the solution?

 

It throws those messages =>

 

See the end of this message for details on invoking 

just-in-time (JIT) debugging instead of this dialog box.

 

************** Exception Text **************

System.Data.SqlClient.SqlException: Dize veya ikili dosya verileri kesilecek.

Deyim sonlandırıldı.

  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

  at Rfbio.DataSet1.GKS_PERSONELDataTable.personel_ekle(SqlConnection connection, DataRow rw_pers, String kisitlama, String dateformat)

  at Rfbio.f_personel.btn_kaydet_Click(Object sender, EventArgs e)

  at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)

  at System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)

  at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)

  at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)

  at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)

  at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)

  at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)

  at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

  at System.Windows.Forms.Control.WndProc(Message& m)

  at System.Windows.Forms.ScrollableControl.WndProc(Message& m)

  at System.Windows.Forms.ToolStrip.WndProc(Message& m)

  at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

  at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

  at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

 

************** Loaded Assemblies **************

mscorlib

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9043 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

----------------------------------------

Rfbio

  Assembly Version: 1.39.1.0

  Win32 Version: 1.39.1.0

  CodeBase: file://10.10.181.200/Barkodes/Rfbio/Rfbio.exe

----------------------------------------

System.Windows.Forms

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9038 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

----------------------------------------

System

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9042 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

----------------------------------------

System.Drawing

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9031 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

----------------------------------------

System.Data

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9031 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

----------------------------------------

System.Configuration

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9031 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

----------------------------------------

System.Xml

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9031 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

----------------------------------------

DevExpress.XtraEditors.v9.3

  Assembly Version: 9.3.4.0

  Win32 Version: 9.3.4.0

  CodeBase: file://10.10.181.200/Barkodes/Rfbio/DevExpress.XtraEditors.v9.3.DLL

----------------------------------------

DevExpress.Utils.v9.3

  Assembly Version: 9.3.4.0

  Win32 Version: 9.3.4.0

  CodeBase: someInfo...../Barkodes/Rfbio/DevExpress.Utils.v9.3.DLL

----------------------------------------

DevExpress.Data.v9.3

  Assembly Version: 9.3.4.0

  Win32 Version: 9.3.4.0

  CodeBase: someInfo...../Barkodes/Rfbio/DevExpress.Data.v9.3.DLL

----------------------------------------

System.Data.DataSetExtensions

  Assembly Version: 3.5.0.0

  Win32 Version: 3.5.30729.9034 built by: WinRelRS5

  CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.DataSetExtensions/3.5.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll

----------------------------------------

System.Core

  Assembly Version: 3.5.0.0

  Win32 Version: 3.5.30729.9034 built by: WinRelRS5

  CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll

----------------------------------------

System.Transactions

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9031 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll

----------------------------------------

System.EnterpriseServices

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9031 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

----------------------------------------

Accessibility

  Assembly Version: 2.0.0.0

  Win32 Version: 2.0.50727.9031 (WinRelRS5.050727-9000)

  CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll

----------------------------------------

rfADMINplus

  Assembly Version: 5.0.0.0

  Win32 Version: 2.0.0.0

  CodeBase: someInfo....../Barkodes/Rfbio/rfADMINplus.DLL

----------------------------------------

FsmUsbDefine

  Assembly Version: 1.0.0.2

  Win32 Version: 1.0.0.2

  CodeBase: someInfo....../Barkodes/Rfbio/FsmUsbDefine.DLL

----------------------------------------

 

************** JIT Debugging **************

To enable just-in-time (JIT) debugging, the .config file for this

application or computer (machine.config) must have the

jitDebugging value set in the system.windows.forms section.

The application must also be compiled with debugging

enabled.

 

For example:

 

<configuration>

  <system.windows.forms jitDebugging="true" />

</configuration>

 

When JIT debugging is enabled, any unhandled exception

will be sent to the JIT debugger registered on the computer

rather than be handled by this dialog box.

 

 


8 replies

Userlevel 5
Badge +9

Hi @Semih Öztürk​ ,

 

Can you share more details on this, What Application, from where you fetched this logs?

Userlevel 3
Badge +7

Hi @Semih Öztürk​ ,

 

The above logs are generated by automation anywhere?

Userlevel 2
Badge +8

Hi @Tamil Arasu​ 

 

Thank you for replying, to be honest this may not be about AutomationAnywhere, but just wanted to ask if someone else had this problem when they worked with some other applications.

 

Finally, i found the solution, there is a textbox about PersonelJob, if its too long character, the program doesnt Save, and throw error..

 

So its a problem with a database of that program. I asked our customer company to get in contact with the company who made this application.

It was nice to spend time with the issue though, even though it took so much time of me :)

Userlevel 2
Badge +8

Hi @ChanduMohammad S​ 

 

Thank you for replying. The error was about a program where i save some personel details.

 

Finally, i found the solution, there is a textbox about PersonelJob, if its too long character, the program doesnt Save, and throw error..

 

So its a problem with a database of that program. I asked our customer company to get in contact with the company who made this application.

It was nice to spend time with the issue though, even though it took so much time of me 

Userlevel 5
Badge +9

Great @Semih Öztürk​ 

Userlevel 3
Badge +7

Nicely done @Semih Öztürk​ ,

I would like to know about that logs. I believe the logs are created by the .NET windows based application is right?

Userlevel 2
Badge +8

Thank you @ChanduMohammad S​ 

Userlevel 2
Badge +8

Thank you @Tamil Arasu​ 

Yes, I believe so, and it refers to some SQL database problem, which was about limited string characters

Reply