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

Jonas Richard · ‎06-03-2019

Hello Johnathan and all,

I am experiencing the exact same issue!

Any help would be greatly appreciated!

Thanks in advance!

Ary1 · ‎06-19-2019

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

rksnow · ‎09-24-2019

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

chetanb · ‎11-27-2019

@

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

Kevin Moore · ‎02-27-2025

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.