Use PDIs? Take our 5-minute survey to help shape the PDI roadmap.

Target Table Missing in Import Historic NeedIt Data Exercise

Go to solution
dkvasak
Mega Expert

‎07-17-2017 10:06 AM

I'm going through the learning path training and in the Importing Data section I'm trying to import the historic data into my NeedIt table. When I start to configure the table transform map I go to the (mandatory) Target table field and my table isn't there. This is the first time I've had this issue in the exercises. I created a branch and brought information over and imported the historic data set. Any ideas why the standard NeedIt table isn't showing this time?

Thanks!

Labels:
0 Helpfuls
  • 6,294 Views
1 ACCEPTED SOLUTION

Go to solution
Dave Smith1
ServiceNow Employee
In response to dkvasak

‎07-18-2017 08:28 AM 

when I went to enter the target table (x_#####_needit_needit) and it wasn't in the list. So now I'm stuck and can't seem to figure out what happened and why the NeedIt table is not available.

The x_##### prefix suggests to me that it lives within a scoped application.   So, a couple of things:


  1. check you're in the right scope.   If you use the cogwheel top-right to bring up System Settings, under Developer there's an option to show the scope picker in your banner.   Pop that on and you can see where you are
  2. use sys_db_object.list in your Navigation Filter to bring up the list of tables, then search on *needit in the table Name (not Label) to see if the table's there.


I'm hoping that the target table exists but the field for entering it isn't showing up the right information.   However, give those a go and we'll take it from there.


View solution in original post

15 REPLIES 15

Go to solution
chenderson
Giga Contributor

Monday

Hi,
Had similar issue with the Zurich PDI , so used the globe icon (top right) to schnge scope to NeedIt,which worked and the rest of the exercise worked.
Might need a change in the exercises to reflect the change in versions available....

 

0 Helpfuls