Skip to main content
1-Visitor
November 2, 2016
Solved

Some Data Tables created through Service are not displaying.

  • November 2, 2016
  • 1 reply
  • 2690 views

Hello Carles Coll,

I have written a service to create Data Tables dynamically. Service is working fine. Some Data tables created through service are in list of data tables but some are not in list.

I am not getting the reason and where could I see those data tables.

Thanks in advance,

Meenakshi

Best answer by CarlesColl

Hi,

Various things can happen...

  • Visibility --> If you are on Administrator user should not, but otherwise can be a visibility problem ( organizations / visibility )
  • Transactional Problems --> If some of your DataTable creator scripts fail for some reason and throws and uncached exception then you will have a transaction rollback, which can take in effect after a tomcat restart <-- I think that can be your case

Carles.

1 reply

1-Visitor
November 2, 2016

Hi,

Various things can happen...

  • Visibility --> If you are on Administrator user should not, but otherwise can be a visibility problem ( organizations / visibility )
  • Transactional Problems --> If some of your DataTable creator scripts fail for some reason and throws and uncached exception then you will have a transaction rollback, which can take in effect after a tomcat restart <-- I think that can be your case

Carles.

magrawal1-VisitorAuthor
1-Visitor
November 2, 2016

1) I am an Administrator use.

2) I have restarted tomcat and still data tables are not visible.

Data Tables are created but not in list as I am trying to create dt with the same name it is throwing "entity already exist" exception. So it is cnfirmed that Data tables are created.

1-Visitor
November 2, 2016

2) --> Yes That's what I mean, if you have an unfinished transaction ( becouse of a exception thrown) on tomcat restart DataTables will be rolledback --> DataTables removed .

You should not let throw "Entity already exist" exception on the wild --> I think this is the problem, check first if Entity Exist before trying to recreate it, you can easily do it like:

var myDataTable= Things["myDataTableName"];

if (myDataTable==null) {

   // -- you can "safely" create the datatable.

}