question Re: Target Table Missing in Import Historic NeedIt Data Exercise in Developer forum

Target Table Missing in Import Historic NeedIt Data Exercise

dkvasak — Mon, 17 Jul 2017 17:06:13 GMT

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!

Re: Target Table Missing in Import Historic NeedIt Data Exercise

Dave Smith1 — Mon, 17 Jul 2017 17:57:31 GMT

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

Which "learning path training" are you doing?

Re: Target Table Missing in Import Historic NeedIt Data Exercise

dkvasak — Mon, 17 Jul 2017 19:49:31 GMT

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.

Re: Target Table Missing in Import Historic NeedIt Data Exercise

Dave Smith1 — Tue, 18 Jul 2017 10:09:26 GMT

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_needit_application?… ...?

(your images come up blank for me)

Re: Target Table Missing in Import Historic NeedIt Data Exercise

dkvasak — Tue, 18 Jul 2017 14:10:55 GMT

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!

Re: Target Table Missing in Import Historic NeedIt Data Exercise

Dave Smith1 — Tue, 18 Jul 2017 15:28:17 GMT

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.

Re: Target Table Missing in Import Historic NeedIt Data Exercise

dkvasak — Tue, 18 Jul 2017 16:05:00 GMT

Dave!!!! That was it! Turns out I was in the wrong scope. I was able to turn the scope picker on and switch to the NeedIt scope. Then I needed to delete the previously imported data sets that were still linked to the other scope, but after that I was able to smoothly continue with the exercise. I don't know how I landed in the wrong scope, but I'll definitely pay more attention from here out. Thanks again!!!

Re: Target Table Missing in Import Historic NeedIt Data Exercise

Dave Smith1 — Tue, 18 Jul 2017 21:07:44 GMT

Denise Vasak wrote:

I don't know how I landed in the wrong scope, but I'll definitely pay more attention from here out. Thanks again!!!

Good stuff!

You'll find that occasionally you'll get a lot of greyed-out areas in a form because you're in a different scope, and a warning in the annotation bar will prompt you to switch scope - it's possible you did that to switch out. At least having the scope picker helps you see (at a glance) which scope you're currently working in.

Good luck with the rest of your learning, and I hope to see you on one of my Sysadmin courses one day!

(nb: searching for community posts with green ticks is useful to glean snippets of information, since you know they contain the right answer!)

Re: Target Table Missing in Import Historic NeedIt Data Exercise

T_Smith — Fri, 23 Feb 2018 17:00:48 GMT

Hi Dave, I'm experiencing the same issue except with the Source Table instead of the Target Table. I tried the solutions you recommended here but was unable to resolve the issue. One, the sys_db_object.list yields no results regardless of which scope I'm in (Global/Needit/Innovate), and two, when I'm in Global scope my Needit target table is not available, but when I'm in Needit scope it is available. Nonetheless, the Source table is not available and so I'm unable to create a transfer map. I appreciate any insight you can share.

Re: Target Table Missing in Import Historic NeedIt Data Exercise

Jonathan44 — Fri, 31 May 2019 11:48:52 GMT

Hi @ all, I'm on the learning path for madrid. I finished most of the exercises without having too much trouble. I like to mention that I found it really nice that the lessons and exercises are available alongside the training instance for SNOW. Now, in the lesson of Importing Data I did all the necessary steps - including the "create a branch from a tag" exercise to load all the data that where needed for this lesson.

So I checked with sys_db_object.list that the respective x_<number>_needit_needit table is there in the list (and it is) and I'm also in the right Needit scope (as Dave recommended - checked with picker in the header). But still when I open a dialog for a new transfer map (and I deleted the former imported import set and loaded it newly as earlier mentioned here in this blog) I get the Global scope under Application on that mask and I do not get the right target table in the list of tables (x_<number>_needit_needit)??

(Note:Also I switched back to another scope and it did switch the scope on this mask from global but not for the needit scope!)

I appreciate any help on that.

Cheers,

Jonathan

Re: Target Table Missing in Import Historic NeedIt Data Exercise

Jonas Richard — Mon, 03 Jun 2019 15:22:40 GMT

Hello Johnathan and all,

I am experiencing the exact same issue!

Any help would be greatly appreciated!

Thanks in advance!

Re: Target Table Missing in Import Historic NeedIt Data Exercise

Ary1 — Wed, 19 Jun 2019 20:19:20 GMT

I was facing the same issue, the problem for me (and I guess that for you too) was that there was selected the option "Default[Global]" in the Update Set selector (to the left of the scope application selector).

Then, looking in the Local Update Set table, there was no Update set associate to the NeedIt Aplication (At this point I have no idea what caused it since it's suppose to be created when the application is created)

My solution was to reset and wipe my intance (it takes like 1 hour) and start from 0.
Then, in Studio I selected the Import from Source Control option and linked it to my git repository.

I verified that the Update Set was created and then I changed to the last branch.

Hope you find this useful

PD: This is an solution, maybe not the best. I'm interested on learning what was the problem with the UpdateSet, so if anyone knows what happened and how to fix it, plss reply me

Re: Target Table Missing in Import Historic NeedIt Data Exercise

rksnow — Tue, 24 Sep 2019 19:24:47 GMT

I am also facing the same issue., I can see all other tables coming up except (x_<number>_needit_needit) table! Anyone has solutions?

Re: Target Table Missing in Import Historic NeedIt Data Exercise

chetanb — Thu, 28 Nov 2019 06:02:18 GMT

@rksnow , @Ary , @Jonas Richard

In addition to scope check.

Have eye on Application Access for Needit Table.

(Because, it restricts to insert new record if can create field is unchecked)

Steps to follow-

Go Studio->Click on Needit Application->(Under Data Model->Tables->NeedIt)->under Application access tick can create checkbox.

Refer Screenshot-

Re: Target Table Missing in Import Historic NeedIt Data Exercise

Kevin Moore — Thu, 27 Feb 2025 20:16:02 GMT

I had this same issue and was in the correct scope. For me, changing to another browser fixed my issue. Went from Edge to Chrome. Some browser cache issue.

Re: Target Table Missing in Import Historic NeedIt Data Exercise

chenderson — Mon, 17 Aug 2026 09:50:26 GMT

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