Hi Apptio Community

I'm getting an upload error when I try to check out one of my tables, and upload a new file.   (This isn't happening to every table, just some, right after I drag and drop.)

Can someone explain what this means, or better yet, send me a link, to a list of all the unsuccessful server response codes, so that I can use it as a reference?

Hi

Not sure about the error message number but this sounds like the issue I had whenever I had poor connectivity and the upload failed due to interrupted connection.

I found this is more likely if this is a large file.

Good luck

Rod

Hi 

It is interesting it never happened in V11 but it appears sometimes in V12. I have seen it few times but despite the error massage the file was successfully loaded. I think the number represent HTML error code. You can find the list of HTML error codes here https://httpstatusdogs.com/

That has got to be one of the most funny (yet useful) list of http error codes ever.        

The opposite of this one:   List of HTTP status codes - Wikipedia 

Thanks, Ivan.        FYI, I'm on    r12.5.1.1.0978dc9d4429.75801.

I've also seen this error a few times and engineering are aware of it. It seems to occur when a file is loaded with new or changed columns compared to the original. So the Import step has some errors that need fixing. But I found the upload is always successful, regardless of that message.

Thanks, Nigel.        I couldn't figure this out for sure, until today, because I'm working with a new Apptio implementation, and I also work from several offices, some with poor network connections.     And sometimes I get the error, and sometimes I don't.

But at least I've managed to recreate the 412 error now.       Today, I'm working at a site with a wireless network, and I guess the network is fairly good today, because I didn't get the 412 error that I got yesterday, repeatedly.

So, some final advice from me, in case it helps anyone:

-   In a situation where this is working fine, I deliberately introduced some import errors to my upload file.   I picked one of the Numeric columns, and in Excel changed it to an Accounting format (which substitutes "0"s with "-"s, Apptio can't handle this scenario).    And then when I uploaded the file again, I got the 412 error.

-   Sometimes I didn't see any import errors, but then I switched the month in TBM Studio to the one for the file I was uploading - and then I saw the import errors.

-   The file uploaded fine.    (I have to remember to wait until the upload reaches 100%, and then pause for a bit, before flicking over to the Import step - I'm a bit too impatient when it comes to moments like this!)         To check, I can download the file again, and it will show the 'digested' form of the data.    Skipped rows are left out, numbers are converted to strings if they were overridden as Labels, etc.     The original file isn't kept by Apptio, so in a way, this is a good data check to see what was stored - if I really do want to check.

I have yet to see a list of all errors, but I can tell you this usually happens to me when I am trying to update a table with too many data sets checked out, try to check everything in and roll back the changes to the data set you are trying. Then try again.

Travis Cole

Technology Business Management | O:402-777-4409 | M:402-699-3715

I agree with @Nigel Collins and @Travis Cole. I do not believe Apptio has compiled a list of this type of Unsuccessful Server error. You may want to check the columns headers of the file you are uploading versus what is loaded in Apptio. It can also be some columns shifted due to an extra commas or tab or double quotes within the dataset depending on what type of file format you are loading.

I just got the same error this morning and my data still checked in ok. To Nigel's point, I did have new columns in this upload.

I have this error yesterday. Even though there were data loaded, the header row was all incorrect. I had nothing checkout, cleared the browser history, tried to load at different times of the day, no success.

Support is helping at the moment. When resolved, I will let you know.

I get the same error almost everytime I load a file,  maybe its the servers for my project instance.  The file seems to load OK, I check the table before proceeding with the upload and verification process.

I'm hoping a full production instance in Australia will relieve the issue.

We were getting a similar issue last week with Error 403. We raised a support ticket with Apptio Support - they resolved the issue, however we are yet to find out what the fix was.

We are a based in Melbourne, Australia and did not have connectivity issues at this time.

Hope this helps

I've encountered this error message a number of times and as a few people have mentioned already it's normally due to a change in the data source (either file type change or data content changes). On occasion the file loads and sometimes it doesn't. Apptio Support are aware of it so if you have any issues and the data isn't loading or the error is persistent then drop them a line.

A quick fix I've found is to revert the check out, close the browser and then restart the process, a bit cumbersome but it works

The 403 errors can be caused when a user checks out a table, uploads to it, then reverts the table but leaves the upload step checked out to themselves. Other users will be able to check out the table and try to upload to it but will get the 403 (-200) error. Please ensure that the table you are trying to upload to does not have an upload step checked out to another user.

Additionally, 412 (-200) errors means that the upload succeeded but the validation failed and requires you to check the validation errors (in the import step by navigating to the time period that the data set was uploaded into). Please refer to https://tbmcouncil.jiveon.com/docs/DOC-6571 for validating uploads, or turn off data validation for the table in the Import Step.