LOAD DATA from file erroring after upgrade to 2025.1

Question 1

Question

Don Martin · Sep 5

#InterSystems IRIS #InterSystems IRIS for Health #Health Connect

We have a task that runs objectscript code to load data into a linked external table. After upgrading from 2024.1 to 2025.1, the load is throwing an error, with error code -400, and no error message. The data DOES get loaded into the external table in its entirety, so with no meaningful error message, its hard to determine what the issue is. The result is the same with and without the USING clause, so don't let that confuse you. We have logs of this statement succeeding before upgrade, and were able to get this statement to work in our production environment, which is still on version 2024.1. I have recompiled all namespaces after upgrade, stopped and restarted the JDBC server, and have dropped and relinked the external table, all without success.

Code: LOAD DATA FROM FILE '/intersystems/filepath/loadtest.csv' INTO SCM_Table_sandbox.dontest USING {"maxerrors":0,"from": {"file": {"header":false,"columnseparator": ","}}}

SQL Diagnostic Log:

Start time	2025-09-05 18:07:06.822705
User	xxxx
Status	Complete
Process ID	650691
SQLCODE	-400 - See detailed error messages below
Input record count	0
Error count	2 (max error count: 0)
Statement	`LOAD DATA FROM FILE '/intersystems/filepath/loadtest.csv' INTO SCM_TABLE_SANDBOX . DONTEST USING { "MAXERRORS" :MAXERRORS 0 , "FROM" :FROM { "FILE" :FILE { "HEADER" :HEADER FALSE , "COLUMNSEPARATOR" :COLUMNSEPARATOR "," } } }`

Messages:

18:07:06.848 (server) - info: {"resultid":"21","bufferrowcount":500,"queuesize":2,"statistics":false,"from":{"file":{"file":"/intersystems/filepath/loadtest.csv","columns":null,"header":false,"types":null,"columnseparator":",","lineseparator":"\n"},"select":["name","id"],"intotypes":[12,4]},"into":{"table":"SCM_Table_sandbox.dontest","hints":"","columns":["name","id"],"types":[12,4],"values":["?","?"],"bindings":[0,1],"jdbc":{"threads":3}}}

18:07:07.123 (FileReader) - completed: Reader Complete: Total Input file read time: 42 ms,

18:07:07.124 (JdbcWriter) - completed: Writer Complete: Total write time: 45 ms,

18:07:08.219 (JdbcWriter) - completed: Writer Complete: Total write time: 1142 ms,

18:07:08.220 (JdbcWriter) - error: 1

18:07:08.220 (JdbcWriter) - abort: 1

Any help would be appreciated!

-Don Martin, Sanford Health

Discussion (0)1

Log in or sign up to continue

Question 2

Question

Vegas Vapor · Sep 5

#Compatibility #Performance #Global Masters

The vaping world continues to evolve with innovative devices that make every puff smoother, more flavorful, and more satisfying. Among the latest launches, the Vaporesso Xros 4 Nano Pod Kit has quickly gained attention for its impressive combination of portability, performance, and advanced features. Built to deliver a premium experience in a compact form factor, this device appeals to both new vapers looking for convenience and experienced users seeking customization.

In this detailed blog, we will take an in-depth look at the Xros 4 Nano Pod Kit, its specifications, design, performance, and all the little details that set it apart. Whether you’re after a flavorful mouth-to-lung (MTL) session or a smooth restricted direct-lung (RDL) vape, this pod kit is designed to give you the best of both worlds.

Compact Design with Big Capabilities

One of the standout features of the Xros 4 Nano is its compact, pocket-friendly design. Measuring approximately 56.5 × 55 × 20.9 mm, the device slips easily into your pocket or bag, making it perfect for vaping on the go. Despite its small size, it feels sturdy and durable, thanks to its aluminum-alloy unibody construction. The design not only adds to its durability but also gives it a premium texture that feels comfortable in the hand.

The balance between size and performance is what makes this device special. It looks stylish without being flashy, and its build quality ensures long-lasting use. For users who value both portability and durability, the Xros 4 Nano Pod Kit delivers on all counts.

Strong Battery Life and Rapid Charging

Battery life is one of the most important considerations for any pod kit. The Vaporesso Xros 4 Nano features a 1350 mAh internal battery, which is one of the largest capacities in the Xros series. This powerful battery ensures long-lasting vaping sessions without constant recharging, making it an excellent choice for heavy vapers.

When it does need charging, the USB Type-C 2A fast charging system gets the device back to 80% in just 20 minutes. That means less waiting and more vaping. A full charge easily lasts throughout the day, depending on usage, which is ideal for both casual and consistent users.

Vivid TFT Color Display

Unlike many compact pod kits, the Xros 4 Nano comes with a 1.3-inch circular TFT color display. This bright, sharp screen shows essential information like battery percentage, wattage, puff count, and mode selection. What makes it more interesting is the ability to choose from three customizable themes: Flower, Motion, and Universe.

This feature allows users to personalize their vaping experience visually, adding a fun and modern touch to the device. The screen makes it easy to stay on top of your settings at a glance, making the Xros 4 Nano Pod Kit not just functional but also engaging.

COREX 2.0 Technology for Superior Flavor

At the heart of the Vaporesso Xros 4 Nano Pod Kit is its advanced COREX 2.0 mesh coil technology. This technology enhances heating speed and improves temperature control, delivering a more consistent vaping experience.

With COREX 2.0, you can expect:

30% better flavor thanks to improved mesh design and faster heating.
30% longer pod lifespan because of upgraded cotton that resists burning and maintains performance.
15% more vapor production, perfect for those who enjoy thicker clouds.

The result is a richer, fuller flavor profile and smoother hits, whether you’re using freebase e-liquids or nicotine salts.

Pod Versatility and Easy Refilling

One of the greatest strengths of the Xros 4 Nano is its full compatibility with all Vaporesso Xros pods. This includes pods ranging from 0.4 Ω to 1.2 Ω, giving you the flexibility to switch between different vaping styles.

The device usually comes with a 0.4 Ω COREX 2.0 pod pre-installed, along with a spare pod, often a 0.8 Ω option. This makes it ideal for experimenting with both MTL and RDL vaping.

Refilling is effortless thanks to the top-fill clamshell design. Just pop open the cap and fill without removing the pod from the device. The pods also include Vaporesso’s SSS leak-resistant technology, which prevents messes and keeps your e-liquid securely in place.

Customizable Wattage and Airflow

Vapers who like to fine-tune their experience will love the adjustable options on the Xros 4 Nano Pod Kit.

When using the 0.4 Ω pod, the device allows precise wattage adjustment in 0.5 W increments. This gives you incredible control over vapor production and flavor intensity.
With other pods, you can select from three preset modes: ECO (longer battery life), Normal (balanced performance), and Power (maximum output).

In addition, the slider-style airflow control lets you adjust between tight MTL draws, looser MTL, and smooth RDL vaping. This adaptability ensures that every user finds their perfect balance.

Dual Activation for Ease of Use

The Xros 4 Nano Pod Kit offers both button activation and auto-draw activation. Beginners may prefer auto-draw for its simplicity, while experienced users often enjoy the tactile control of pressing a button. Having both options makes the device versatile and user-friendly.

What’s Inside the Box?

When you purchase the Vaporesso Xros 4 Nano, the package typically includes everything you need to start vaping right away:

1 × Xros 4 Nano Device
1 × 0.4 Ω COREX 2.0 Pod (pre-installed)
1 × Spare Pod (commonly 0.8 Ω)
1 × USB Type-C Charging Cable
1 × Lanyard
1 × User Manual
1 × Warranty Card

The packaging itself is sleek and premium-looking, often with clear labeling, product images, and authenticity verification. It makes the unboxing experience enjoyable while ensuring you get a genuine product.

A Spectrum of Colors

The Xros 4 Nano Pod Kit is available in a variety of stylish finishes to suit different personalities. Some of the most popular colors include:

Graphite Black
Titanium Silver
Aquamarine
Twilight Purple
Camouflage
Race Track
Word-pop Blue
Word-pop Yellow

From sleek metallics to bold graffiti-inspired prints, the range of choices allows users to pick a device that reflects their style.

Technical Specifications

For those who love the details, here are the key specifications of the Vaporesso Xros 4 Nano Pod Kit:

Battery Capacity: 1350 mAh (rechargeable)
Charging: USB Type-C, 2A fast charging
Pod Capacity: 3 mL (standard) / 2 mL (TPD version)
Compatible Pods: All Vaporesso Xros pods (0.4 Ω – 1.2 Ω)
Display: 1.3-inch TFT color screen
Output Power: 1–30 W
Filling System: Top-fill clamshell or side-fill
Airflow: Adjustable slider for MTL to RDL
Dimensions: ~56.5 × 55 × 20.9 mm
Build Material: Aluminum alloy

Why Choose the Xros 4 Nano Pod Kit?

There are countless pod kits available, but the Vaporesso Xros 4 Nano stands out for several reasons

Powerful Battery – All-day usage with fast recharging.
Advanced Technology – COREX 2.0 enhances flavor, vapor, and pod longevity.
User-Friendly Controls – Simple enough for beginners, customizable for experts.
Stylish Variety – Multiple finishes to match any personality.
Pocket-Sized Durability – Compact but built to last.
Complete Kit – Comes with everything needed to get started.
Full Pod Compatibility – Works seamlessly with the entire Xros pod range.

This balance of convenience, performance, and versatility makes it one of the most well-rounded devices currently available.

Final Thoughts

The Vaporesso Xros 4 Nano Pod Kit is proof that small devices can deliver big performance. With its powerful battery, stunning display, leak-resistant pods, and innovative COREX 2.0 technology, it creates a vaping experience that is smooth, customizable, and enjoyable.

Whether you are switching from disposables, upgrading from an older device, or simply looking for a reliable daily pod kit, the Xros 4 Nano deserves your attention. It combines sleek design, advanced features, and user-friendly operation into a device that feels tailored to every kind of vaper.

If you value flavor, convenience, and innovation, this pod kit will elevate your vaping journey to the next level.