Error of InsertDataTable activity

Help
, , ,
1

I test the InsertDataTable function, but fail.

1.READ data from an Excel file. Pass
2.WRITE data to another Excel file. Pass! it shows the read and write activity setting is correct.
3.Insert data to Oracle data base, it shows the error:
Insert: Object reference not set to an instance of an object.

1
1637×597 13.1 KB

output

What’s the problem? How to solve it?
Many thanks!

2

Hi Rale , welcome to the Uipath community forum
There could be multiple reasons for it

  1. Is the datatable in the DB having same number of columns as with the Datatable from which you are passing the data ?
    2)Table name correct ? mismatching with upper/lower cases/ spaces at trials
  2. In the variable pane of datatable “dtTest” at the default value give as “New.system.data.datatable”
3

Thanks!

1.I have checked the table structure, it is the same between RPA_CASELIST and savedate_test.xlsx .
Table name is all the upper cases char.
2.I show an complier error when I set the variable default value to “New.system.data.datatable”. Would it be some mistaken for this expression?

4

Hi , there is a typo mistake
It’s new system.data.datatable

1 Like
5

Fine
can i have a view on the property panel of INSERT activity with a screenshot if possible

Cheers @Rale

6

GREAT!
“new system.data.datatable” works well.
Thank your great support!

BTW, I think it’s not reasonable to set the default value. It may be a bug for INSERT function.

7

Thanks!

After adding a default value of “new system.data.datatable” to variable, the problem was solved .

8

Hi , Because sometimes the tool might not recognize the Datatable , so we just need to initiate it by giving default value as New system.data.datatable

Please mark the topic as solved , so that other users with the same issue can refer to it

Cheers
Happy Automation

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.