Target Table Missing in Import Historic NeedIt Data Exercise

dkvasak · ‎07-17-2017

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!

Dave Smith1 · ‎07-18-2017

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:

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
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

Dave Smith1 · ‎07-17-2017

Where does this NeedIt table come from? Was it one you needed to create?

Which "learning path training" are you doing?

dkvasak · ‎07-17-2017

I'm on the New to Service Now learning path for Istanbul. We created the NeedIt table way back in the beginning and every other time I've needed to use it (just over halfway through the path) I have been able to. I'm still trying to figure out how to delete some of the example stuff so I can start over and see if I somehow missed something.

Dave Smith1 · ‎07-18-2017

Denise Vasak wrote:

We created the NeedIt table way back in the beginning and every other time I've needed to use it (just over halfway through the path) I have been able to.

Okay.. so is it now missing?

I'm still trying to figure out how to delete some of the example stuff so I can start over and see if I somehow missed something.

Did you delete it as part of the example stuff, and now it's needed? As you created it before, can you recreate it?

I'm on the New to Service Now learning path for Istanbul.

I don't know what this is, unfortunately - do you mean this? https://developer.servicenow.com/app.do#!/trainlist/app_store_learnv2_buildneedit_istanbul_build_the... ...?

(your images come up blank for me)

dkvasak · ‎07-18-2017

I responded from email and it put in blank images. Not sure why since there weren't any images.

Yes,the link you added was one of the ServiceNow learning paths. Basically if you go from the beginning you are building upon previous lessons. Once you have the NeedIt table (in the beginning) you never delete it as it's used in every exercise. At the beginning of each module they have you fork the repository f this is your first module and if not, skip to creating a branch for this set of exercises. For this particular module I created the branch and prepared the data for importing. I downloaded the historic data set and was in the process of creating a Transform Map 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.

Any suggestions? Thanks!